macro to retain Certain Data

I have a list of suppliers in Col B


I need a macro to retain only those that contain the items below and to delete the balance from row 2 onwards

1) ETE
2) Auto
3) BRM Investments


Your assistance in this regard is most appreciated

1 Everything with the prefix 'ETE'
2 Does Auto include Auto works
3 Are texts prefixed BR BRM Investments
4. Are the balances of all of the others to be removed or the whole line, you know what you want to do, hard to guess from here

just these few pointers would help a lot

Thanks for the reply

1) Everything with the prefix 'ETE' to be included
2) Auto include Auto works
3) texts are not prefixed BR BRM Investments-Only include BRM Investments

4) All items items are to be deleted from row 2 onwards


Sorry for not being clearer in Post #1

Hi Sinek

I want to retain the following items in Col B

1) Those that are prefixed with ETE
2) Those that are prefixed with Auto
3) Those that contain BRM Investments (not in sample data)

All the the rows from 2 to be deleted , except the items mentioned above

try on a copy of data

Please Login or Register  to view this content.

Hi Guys

Many thanks for the help. Have tested your code and they both work perfectly