Im looking for a macro/code to KEEP only the rows containing certain text, and delete the remaining rows. This is a little tricky because for example I want to keep rows containing "xxxx" and to keep rows containing "yyyy", and "zzzz", then delete or clear all remaining rows.
The tricky part is that once the code find the rows containing "xxxx" it cannot immediately delete ALL other rows because some of those rows may contain "yyyy" or "zzzz".
The tricky part is that once the code find the rows containing "xxxx" it cannot immediately delete ALL other rows because some of those rows may contain "yyyy" or "zzzz".