Hello!
I have a large data file that is exported from another database that I need to filter and delete rows that don't match certain criteria. This worksheet has between 40,000-80,000 rows and after it's cleaned up sits at around 50% of its previous size. I have tried writing a macro to delete what I don't need, but it does it row by row, I was wondering if I could get help automating this!
What I'm looking for it to do:
1. Delete any row that doesn't have "CHECKED IN" or "CHECKED OUT" in Column O
2. Delete any row where the value in Column AI is less than 69
3. Delete any row where Column AH doesn't contain "CKOT" or "CKIN"
Thanks!
Bookmarks