Adding Ranges, increasing worksheets

  • Thread starter Thread starter ZootRot
  • Start date Start date
Z

ZootRot

MS Excel 2002

Every month I add a spreadsheet for that month's details. The structure
remains the same, but the data content differs. Is there any way I can add
the contents of all the sheets instead of adding to the formulae in the
summary worksheet each month?

Preferably want to use formula in cells, VBA as a last resort?
 
Put in two sheets

name them Start and End

Insert your monthly sheets bewteen these two so your tabs look like

Summary Start Month1 Month2 . . . End

In the summary sheet use a 3D formula

=Sum(Start:End!A1)

When you add monthly sheets, put them between start and end (start and end
should be blank).

this will sum all the A1 cells in the monthly sheets (the sheets between
start and end. Start and end will be included, but being blank will not
affect calculations).
 
Back
Top