Delete column a if keyword is in column b

[fernandosaez]

I work for an export business and we have over 4,000 products and over 10,000 people we export to around south america.

I was presented a list with the contact info in the left and on the right a paragraph that contains the items that have been purchased before in the past.

Can you guys help me with a code that will delete a row (a and b) if a keyword or words is present in b? So if it contains the word trumpet or horn it ill delete that whole row.

THANKS FOR YOUR HELP!

Looks like this
https://dl.dropbox.com/u/9443/help please.xlsx

 

[Michael M]

Yes you can.