| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summarise data from several worksheets in a workbook
I have the same abolute cell reference across several named worksheets in a
workbook. I wish to summarise this data in a new "summary sheet". Does anyone know how to increment the worksheets in a formula, so that when I use the "fill handle" in the summary sheet it will bring in the data from each of the worksheets. Many Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summarise Multiple Worksheets | Excel Worksheet Functions | |||
| create sheet to summarise invoices on other worksheets | Excel Discussion (Misc queries) | |||
| How to summarise data in the same place in multiple worksheets? | Excel Discussion (Misc queries) | |||
| How do I summarise data from several workbooks? | Excel Discussion (Misc queries) | |||
| summarise totals from many worksheets into one final worksheet | Excel Worksheet Functions | |||
Threaded Mode
