Hello,
I am new to using Macros in excel (2003) and I am having problems writing a code to do the following.
I have a spreadsheet with 100 rows. I would like to add a button to the spreadsheet to delete all completed rows based on the "Yes or No" response in the cell. Anytime there is a Yes in column K, I would like the button to delete the rows and shift the information up. I have a formula in column B that auto numbers the task. In columns I and K I used data validation to have the user select the priority level and the Yes/No response.
The rows start on #6.
I have attached a sample spreadsheet.
Any help would be greatly appreciated.
Thanks!
Bookmarks