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.
I have tried to use this code but it doesn't work!!!
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.
I have tried to use this code but it doesn't work!!!
Code:
=HLOOKUP(AB4,INDIRECT("'"&INDEX(SheetList,MATCH(TRUE,COUNTIF(INDIRECT("'"&SheetList&"'!$B$5:$H$11"),AB4)>0,0))&"'!$B$5:$H$11"),3,0)How to do it?
