About Us

joel

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Accumulating a total	JD	Excel Worksheet Functions	4	January 19th 09 11:00 PM
accumulating values generated daily	Tracey	Excel Worksheet Functions	1	April 15th 06 08:07 AM
Accumulating Values in a Pivot table	Kurt	Excel Discussion (Misc queries)	2	March 2nd 05 08:42 PM
Accumulating data	legepe[_4_]	Excel Programming	2	October 21st 04 01:54 AM
Undesired Rounding in VBA; accumulating values	Glenn Ray	Excel Programming	5	January 25th 04 10:01 PM

Menu

About Us