Delete entire row is cell contains a word except if the cell contains a specific phrase.

Hi,

I do have a long worksheet with a lot of information; out of which only a handful is needed.

I was able to write a macro (from seeking help here itself) to delete all the rows that contained "HELP" in Column B, for example, and that was working fine so far.

However, I have noticed that at times, I needed the information from cells that contained "HELP ME". Here is an illustration below:

Original Data:
Column B
HELP! 123
CAN I HELP?
NO THANKS
HELP ME 221
PLEASE HELP ME
HELP HELP HELP
12345

Wished Data:
Column B
NO THANKS
HELP ME 221
PLEASE HELP ME
12345

As you may notice, all the words cells that contained "HELP" was deleted except if the cell contains "HELP ME". My code so far is:

Please Login or Register  to view this content.

Any help is much appreciated, thanks!

as an option

Please Login or Register  to view this content.