@ ewso

You've indicated the need of a 'script' to do what you want, but have given ZERO other information.

Expecting a 'works for me' macro without providing a sample worksheet indicative of what you're working with is unrealistic.

You say "doesn't have certain words or phrases that I specify."
Then in response to Logit's suggestion you say "i have multiple words/phrases that i need to use as my criteria"


which seems to indicate "that I specify" is more likely "have in a list", but you're not saying that.

Would you care to post a sample workbook so we're all on the same page and know what is being dealt with?