Need a macro to delete all rows not meeting a criteria in column A

I need a macro that will delete all rows that don't have Ye in column A. This Macro would apply to columns A, B, & C from row 2 down.

Thanks!

Example of what I want:
MACRO EXAMPLE.xlsx

The quick and dirty way to do this is filter Col A by everything not equal to Ye. From there you can select all the rows and delete them. No VBA needed.

Originally Posted by day92

The quick and dirty way to do this is filter Col A by everything not equal to Ye. From there you can select all the rows and delete them. No VBA needed.

A macro is needed, please. I don't have the time to delete all the rows manually. There can be 1000s of rows per sheet and I have to do this to 20+ workbooks with 12 sheets each, I need to have this done with a macro.

Ok here you go. This should do the trick.

Please Login or Register  to view this content.

WOrks perfect, thank you!