![]() |
Deleting things automatically in Excel
Hi,
I have been developing a timetable booking form in Excel for 3 ICT rooms, however after a 2 week period i want to delete some values automatically, I haven't really got a clue where to start looking for answers, Is there a way to do it through VBA? Is there actually a way to do this through Excel (Deleting things automatically that is)? |
Deleting things automatically in Excel
Of course, you can do almost anything in Excel with a macro. Why not try
recording one yourself? Click on Tools Macro RecordNewMacro and then follow the menus and go through the steps manually of deleting the data you wish.........when finished, you will have a macro that will do it for you automatically the next time you need it done. Be sure to practice this on a copy of your file, not the real one, and post back if you have questions. hth Vaya con Dios, Chuck, CABGx3 "Martin" wrote: Hi, I have been developing a timetable booking form in Excel for 3 ICT rooms, however after a 2 week period i want to delete some values automatically, I haven't really got a clue where to start looking for answers, Is there a way to do it through VBA? Is there actually a way to do this through Excel (Deleting things automatically that is)? |
All times are GMT +1. The time now is 07:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com