| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Consolidating multiple sheets
I have over 70 sheets with the exact same layout which I want to consolidate.
There is a list of all the sheet names on my summary page in Cells L6:L77. I tried using: =SUM(INDIRECT("'"&L6:L77&"'!AV32")) with AV32 being the first cell on each sheet I want to summarise. But it only returns the amount from the first sheet. Any ideas? -- http://www.redbrick.dcu.ie/~pele |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| CountIF across multiple sheets in a workbook | Excel Worksheet Functions | |||
Threaded Mode
