template that clears everyday saves old one

May 25, 2011 at 10:08:26
Specs: Windows XP
we have a business template where we add in numbers and have certain formulas in some cells to calulate totals for the day. is there any way to fill in this template at the end of the day and have it save, then the next day have the same template but blank, ready for a new day's numbers. And is there any way to have the date saved as a header so we can print out the sheet without manually typing in the date every time... not sure how else to explain ite

See More: template that clears everyday saves old one

Report •

May 26, 2011 at 00:18:00
themexiranian, sounds like a programming problem to me. Suspect you'll find more succinct answers in the Programming forum?
I'd think you can simply save a blank template somewhere as a document, retrieve it in your favorite word processor, then fill in the cells as you like and save the new document titled today's date. You'd still have to type in the date/title though. There's a variable your computer uses holding today's date. Perhaps you could write a short script to use that variable?
Ed in Texas

Report •
Related Solutions

Ask Question