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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to do a mailmerge from a Specific Excel worksheet 0
Embed the same Excel multiple times 0
Microsoft 365 Activations, Users or Devices? 0
Syncing between source worksheet and dependent worksheets 0
Excel automatically goes into 'Group' mode while toggling between worksheets 1
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Close all without saving and exit without prompts 8
Can't save my Office documents (after computer rebuild and reauthorization) 0

Top