Auto Filter and Auto Format

[ryannjohnsonn]

Hello! I have another quick question!

I have a large sheet imported from another program that varies in length from 30,000-80,000 rows. I'm making a macro that will completely format it for me in a way that is understandable rather than spending an extended amount of time each month setting it up.

I want to include in my macro the ability to delete any row where Column O isn't equal to "CHECK", Column I is less than 69, Column F is less than 1, and Column H is not equal to CKOT.

I've played around with this, and anything I do goes line by line, which as you can imagine would take forever with 80,000 rows. I assume theres a way to filter it with VBA to quickly purge the unnecessary data?

After that data is deleted, I want to sort the data alphabetically based on Column C

Thanks for the help!