Accumulating values from one page to another.
 

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

Accumulating values from one page to another.
 

The entire process can be done in a single macro. If you send the filename
you are saving, and the cell which has the previous total I can write the
macro pretty quickly. It will change he filename to a new filename,perform
the save as, clear the worksheet, and keep the previous day total.

"Gsotoolman" wrote:

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

Accumulating values from one page to another.
 

If you would like, I can email you a copy of the sheet so you can see what I
am trying to do.

"Joel" wrote:

The entire process can be done in a single macro. If you send the filename
you are saving, and the cell which has the previous total I can write the
macro pretty quickly. It will change he filename to a new filename,perform
the save as, clear the worksheet, and keep the previous day total.

"Gsotoolman" wrote:

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

Accumulating values from one page to another.
 

sent it to me at my e-mail address below

mail:

"Gsotoolman" wrote:

If you would like, I can email you a copy of the sheet so you can see what I
am trying to do.

"Joel" wrote:

The entire process can be done in a single macro. If you send the filename
you are saving, and the cell which has the previous total I can write the
macro pretty quickly. It will change he filename to a new filename,perform
the save as, clear the worksheet, and keep the previous day total.

"Gsotoolman" wrote:

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