Delete Rows where cells does not meet criteria

G

Guest

My workbook has 14 columns and more than 1000 rows.
Column C header is Last Payment Date and Column F header is Next Payment Date.
I need to DELETE all rows that has a different date other than 9/1/05 in
Column C and 10/1/05 in Column F.

Everyday, I temporarily insert a column in Column A, copy Column C, paste in
Column A, sort and delete the rows (same procedure for Column F).
Is there a worksheet function or macro that will automatically do this?

Thanks for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select rows which satisfy 2 criteria 16
Counting rows that meet multiple criteria 5
Delete rows based on contents of Col A 0
Count if dates meet certain criteria 10
How do I set up a formula to give me an average based on IF? 1
Delete rows if AF and AY empty but F has information 6
How to Use two search criteria in one array. 2
match and sort two different tables 2

Top