How do I get an excel worksheet to autoclear

[promisman]

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

Can this be done?

[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

"promisman" <[email protected]> wrote in message
news:[email protected]...
> I need to format a worksheet to automatically clear every 24 hours,
saving
> the information first to another worksheet.
>
> Can this be done?