Remove all rows EXCEPT those with specific string in specific column

[noname91]

Hello all,

As the title says, I'm trying to modify a macro that was originally used to remove all rows containing a set of strings in specific columns, to now remove all rows except those with a specific string in a specific column.

I have the following, which doesn't give any error but does not seem to do anything:

Please Login or Register  to view this content.

I have attached a sample workbook with the original sheet ("Sheet1"), and a results sheet, along with the macro. Simply click on the button to run the macro, though as I said earlier, it won't do anything other than show a message.

Thanks for any help.

[Greg M]

Hi there,

Take a look at the attached version of your workbook and see if it does what you need. It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[noname91]

Hi Greg M.

Works perfectly! Even allows for easy adjustment to allow for more than one exception strings.

Thanks again!

[Greg M]

Hi again,

Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M