Forum Discussion
Excel 365 - automatically delete rows from sheet at the end of every week
Hi there, We're using Office 365 and i've been tasked with the contents of a table within a certain sheet on an Excel spreadsheet to be deleted at the end of every week, I had a look around and...
If you can do it manually, you can record the steps and create a macro in VBA (Tools, Macro ........).
But you say you are not familiar with that. Not sure what Developer Tools you refer to. There is a ribbon called "Developer" which can be made visible at will.
Please clarify your needs and upload a sample file. Indicating what needs to be deleted and based on what criteria. Then we can have a look at it.