How do I get an excel worksheet to autoclear

P

promisman

I need to format a worksheet to automatically clear every 24 hours, saving
the information first to another worksheet.

Can this be done?
 
B

Bernie Deitrick

promisman,

Sure. Use a macro that copies the sheet to a new sheet, names it, then
clears the original sheet, and finally reschedules itself using the
Application.Ontime method. If you need help with the specifics, repost.

HTH,
Bernie
MS Excel MVP
 
Top