tmd63
New Member
- Joined
- Feb 21, 2014
- Messages
- 40
- Office Version
- 2013
- 2003 or older
- Platform
- Windows
I have a multiple sheet workbook that has 7 dates on a row with values listed under those dates in up to 7 rows.
I also have a collection sheet with a moth of dates in a column.
I want to search all 53 sheets for a date on the collection worksheet. When a date is found, I need to copy the data from the rows below that date into the cell referenced.
How to do it?
I also have a collection sheet with a moth of dates in a column.
I want to search all 53 sheets for a date on the collection worksheet. When a date is found, I need to copy the data from the rows below that date into the cell referenced.
How to do it?