I have been trying to find a way to Filter two Columns. First by filtering the "Part number" so that they are grouped, which I believe I have done in VBA.
From there I want to filter the "Status" column by removing anything with an "F", then deleting that row.
Next remove anything else that does not contain "Pass", "P_TC" and "PTC". These guys are keepers. All that should be left when filtering the "Status" column is "Pass", "P_TC" and "PTC".
Just cant seem to filter the "Status" Column like I did with the "Part Number" column...
Im thinking of just deleting everything that does not contain the key words first, then filter the "Part Number Column".
So... In Summary, Just really need to Filter the crap out of the "Status" Column and delete said crap.
Any help in the right direction will be valued.
Thank you in advance.
Bookmarks