Hi. Please see attached workbook. forum.ozgrid.com/index.php?attachment/50295/
I would like a macro to:
Find the cell with the first date value in Column A based on the cell value in J1.
Select a range from the cell that was found in Column A, 16 rows down and 7 Column across.
Then I will copy the selected range and paste in a specific cell (I think I know how to do that.)