| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
| How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
| Need to remove a password that noone placed on Excel worksheet. | Excel Worksheet Functions | |||
Linear Mode
