Calculating Month to Date on a Summary Sheet

[Guest]

Good Morning. I have a summary sheet for an entire month of data, and 31 seperate tabbed sheets for each day of the month. Is there a quick way to set up the month to date summary 'totals' in each cell? Currently, I am holding control and going into each cell on 31 sheets after =sum
I'm sure there is a quick way to calculate, and I hope so, as I have about 15 cells that I would like to calculate on the summary page
Any help would be greatly appreciated!!
Thank you
Bradley

 

[Peo Sjoblom]

Please refrain from multiposting, it just wastes people's time and fragments
answers
in search engines

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

Good Morning. I have a summary sheet for an entire month of data, and 31

seperate tabbed sheets for each day of the month. Is there a quick way to
set up the month to date summary 'totals' in each cell? Currently, I am
holding control and going into each cell on 31 sheets after =sum(

I'm sure there is a quick way to calculate, and I hope so, as I have about

15 cells that I would like to calculate on the summary page.

 

[Frank Kabel]

Hi
see your post in Excel.misc
P.S.: please don't multipost