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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summarise data from several worksheets in a workbook
not sure what you want.
on the summary sheet in A1, for example, enter =sum( then select the first sheet tab and press shift while you click the sheets you want to sum then click the cell you want to sum enter the closing ) and press enter it should look like this =SUM(Sheet1:Sheet3!A1) if that's not what you want, sorry. -- Gary Keramidas Excel 2003 "Denis" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summarise data from several worksheets in a workbook
INDIRECT holds the key for you
In your summary sheet, Assume your source sheetnames are listed in A2 down (Sheetnames must match exactly with what's on the tabs, except for case) Assume the key cell refs to be extracted from each source sheet are listed in B1 across, eg: B2, E5, etc Put in B2: =INDIRECT("'"&$A2&"'!"&B$1) Copy B2 across/fill down to populate the required extracts in one fell swoop Celebrate your success, click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Denis" wrote: I have the same absolute 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 |
Reply |
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 |