| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pull data from multiple sheets with formula referencing a tab name
Hi - I can't figure this out and hoping someone can help. I have 25 sheets &
I need data from a row from each sheet. The 25 files have file names which equal cell A8 plus audit.xls = 6L audit.xls (All names are in column A) The tab names are dates in this format m-d-yy in from H5 I am trying to pull the value in K10 This formula is not working: ="='["&(A8)&" audit.xls]"&H5&"'!K$10" What am I doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to pull data from multiple sheets (and Word docs too) | Excel Discussion (Misc queries) | |||
| to pull from multiple sheets-index,match,vlookup,if,and,or??? | Excel Worksheet Functions | |||
| pull data from multiple sheets based on input | Excel Worksheet Functions | |||
| Formula Referencing data on multiple worksheets | Excel Worksheet Functions | |||
| Referencing multiple criteria to pull data | Excel Discussion (Misc queries) | |||
Threaded Mode
