sent it to me at my e-mail address below
mail:
(E-Mail Removed)
"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
Similar Threads
