Summarise data from several worksheets in a workbook

[Denis]

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

 

[Gary Keramidas]

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.

 

[Max]

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