jmendenhall22
New Member
I have todays date in a1
I have names in b3 to b25 (not every cell will always have a name, can be empty)
I have dates spread throughout cells F3 to AZ25, also have cells with initials and blank cells. (All cells in array have formulas in them.)
On sheet2 I want to compare todays date (A1) with (sheet1) dates F3:AZ25 in array of cells and if they match then get name from B3:B25 and place in column (B) sheet2. This may have anywhere from 0 to 25 names.
I would like the returned names to fill in row b3 to b25 with no empty cells between names.
Is this possible??
I attached the workbook
Thank you for your time.
I have names in b3 to b25 (not every cell will always have a name, can be empty)
I have dates spread throughout cells F3 to AZ25, also have cells with initials and blank cells. (All cells in array have formulas in them.)
On sheet2 I want to compare todays date (A1) with (sheet1) dates F3:AZ25 in array of cells and if they match then get name from B3:B25 and place in column (B) sheet2. This may have anywhere from 0 to 25 names.
I would like the returned names to fill in row b3 to b25 with no empty cells between names.
Is this possible??
I attached the workbook
Thank you for your time.