Delete rows based on the value of two columns using VBA code - Multiple worksheets

I have multiple worksheets in my Excel file. From each worksheet, I wish to:

(1) First, delete all rows except those for which Column1 = 0700, 0701, 0703, or 0704;
(2) Then, from the remaining records, delete all rows except those for which Column2 = 07, 08, 09, or 10

The column names (Column1 and Column2) and the placement of those columns (Column1 is under Excel column header "D" and Column2 is under Excel column header "K") is consistent among all of the worksheets.

How can this be done using VBA code?

I have no experience at all with VBA, and doing this manually on the many worksheets would be very time-consuming!

Thank you!!

Maybe:

Please Login or Register  to view this content.

This code runs on all the worksheets. And I don't think you need to think of it as "the remaining records", you can just do both checks on the same pass.

Please Login or Register  to view this content.

Thank you--I appreciate your response!

Great! If you feel your questions have been answered sufficiently, please mark this thread as SOLVED.

And I'm sure anyone who provided good responses would appreciate reputation (the * in the lower left of the posts).