summarizing data from different sheets.

  • Thread starter Thread starter Pal
  • Start date Start date
P

Pal

I have a file with about 70 sheets planed - not sure of limit allowed but
that is goal.
I want to summarize data from a cell on each sheet into a column on a
summary sheet.

Do I have to type in the name of each sheet in my summary page cell in order
to call that cell or is there an easier way to do that - something like a
copydown of an absolute cell reference but will get from the reset of the
sheets in the file. Note that all the sheet names are unique and not
sequential.

Thanks in advance
 
Insert 2 new sheets, name them First and Last, put all relevant sheets
between these two, and use a 3d Sum-formula:

=SUM(First:Last!TheSecretCell)

Substitue the cell of interest for the TheSecretCell. :)
 
You didn't specify, but if all sheets are of the same
format, ie cell a1 on sheet1 is Sales and cell a1 on
sheet70 is sales you can use the following:

-in the desired cell on your summary sheet hit AutoSum
-click on cell a1 sheet1
-hold down the shift key
-click on sheet 70
-hit enter

If the sheets are not setup the same this won't work. If
so please repost with additional details.
 
yes, all my files are laid out the same so sales in a1 if you will.
But I want a column in summary sheet

so in my summary sheet:
c5 = Sheet1 A1
c6 = Sheet2 A1
c7 = Sheet3 A1
c8 = Sheet4 A1

But the names are not "SheetX" anymore
Thanks
 
Back
Top