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

"promisman" wrote in message
...
I need to format a worksheet to automatically clear every 24 hours,
saving
the information first to another worksheet.

Can this be done?