Help on writing a Macro to delete rows with certain criteria

[cf7046]

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!

[mike7952]

Give this a try

Please Login or Register  to view this content.

[cf7046]

Thank you very much for your help - it worked perfectly!

Thanks again!