AnsweredAssumed Answered

VBA - Excel delete rows not matching criteria

Question asked by Cad Admin on Feb 20, 2018
Latest reply on Feb 21, 2018 by Cad Admin

I have a BOM i exported out to excel. I need to delete all rows not containing my multipal partial criteria.

Basically i want to delete any rows NOT containing "-D" "-S" "-M" "RVS-" or "RVD-"....all other rows need to go.

 

I tried using auto-filter, but that only allow 2 or 3 criteria...i most likely will be adding to the "keep" list...so that wont work i beleive

Outcomes