How do I get an excel worksheet to autoclear
I need to format a worksheet to automatically clear every 24 hours, saving
the information first to another worksheet. Can this be done? |
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? |
All times are GMT +1. The time now is 09:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com