auto sum from multiple worksheets

  • Thread starter Thread starter Michael Higgins
  • Start date Start date
M

Michael Higgins

Hi i have a sheet set up for each week for my work and i am trying to do
auto sums to add each weeks figures from Cell n35 at the end i will have 52
sheets so i would like to know how to add figures from each week
automatically.

Many thanks

Michael
 
Michael

Set up a worksheet sandwich.

First you have a Summary sheet.

Then a blank sheet named Start.

Then a couple of your weekly sheets.

Last have a blank sheet named End

In Summary sheet enter this formula =SUM(Start:End!N35)

As you add weekly sheets insert them between Start and End so's they get picked
up by the formula on Summary sheet.

If you want a balance carry-over from sheet to sheet you will need something
else.

Post back if that is the case.


Gord Dibben MS Excel MVP
 
Back
Top