Summary...Number of shts varies

S

steveh

The number of sheets in my workbook varies from day to day, with unique names for each sheet. I am trying to total cell contents from those sheets on a summary sheet. There is a cell whose contents are common to the sheet name. I am at a complete loss as to where to begin. There is not a lot of information here but I am not sure how to post enough to help. Remove nospam to respond via emai
Thanks in advanc
Steve
 
T

Tom Ogilvy

if you are summing information across sheets and the information is in the
same cell on each sheet, put in a sheet named Start and a sheet named End.
Put all sheets to be summarized between these two sheets.

In the summary sheet use a 3D formula

=Sum(Start:End!A1)

as an example.

All sheets between Start and End will be included in the sum (start and
end should be blank sheets.)

--
regards,
tom Ogilvy

steveh said:
The number of sheets in my workbook varies from day to day, with unique
Click to expand...
names for each sheet. I am trying to total cell contents from those sheets
on a summary sheet. There is a cell whose contents are common to the sheet
name. I am at a complete loss as to where to begin. There is not a lot of
information here but I am not sure how to post enough to help. Remove nospam
to respond via email
 
K

Keith

Or you can do it in VBA and use a for each loop

for each ws in activeworkbook.worksheets
total = total + ws.cells(row,col).value
next

or something like that.
 
Top