I currently use an Excel sheet to keep track of my stores business daily. At
the bottom of the page, the sheet keeps track of the days totals for me and
below that I have a space for the monthly total. Every morning, I open the
previous days sheet and clear the information (except the monthly total) and
"save as" to create the new days sheet. Is there a way to program the sheet
to keep the monthly total for me?

Example.

August 1.
days business of $500 is recorded in cell M36. The sheet does this
automatically.
cell M46 is for my months total, which I have to input myself. $500

August 2
Open the sheet for yesterday and delete all of the variable information,
leaving the months total on the sheet, and save as for today's sheet.
Days business of $500 is recorded in cell M36
Is there a way to have the sheet automatically add the days together, even
though the data is dependent on multiple sheets to be accurate?


I probably haven't described this well enough and I am sorry for that. I
have no training on Excel at all, not even a book. I do everything the hard
way, but I get by. If you need any more information on what I am trying to
do, let me know.

Thanks for any advice.
Tim