Need assitance with macro

[ayk5473]

Hi Folks,

So I have an macro code which searches through "column C" for specific keywords and moves it to "Sheet2" the whole row if it matches the keyword. Example: I made the code to move the whole row if there is a keywords such as "town, county, city, state, etc" I did this because I have over 100,000 data and need to filter through only government entities which might contain words like county, town, city, etc

However, now I am facing a 2nd problem which is on Sheet2 contains companies who have keywords such as "town, city, etc" and would like them removed. Example: There might a company "ABC Township Inc"

What I would like to do is create a 2nd macro to remove these keywords from "Sheet2". Is there a code that can help me with this. Thank you so for much your time and effort folks.

 

[ayk5473]

Just tried the code and does not seem to be working. Changed the keyword to be specific

 

[tonyyy]

I am sorry if I am being to vague...

No need to be sorry, but it's still not clear - to me anyway - what you're now trying to accomplish. Should the row on Sheet2 that includes the phrase "Township County Incorporation" be deleted? Why? Because "Township" includes the keyword "town"? Because "County" is a keyword? Because "Incorporation" is not a keyword?

Again, sample data might help clarify things.

 

[Truiz]

Just tried the code and does not seem to be working. Changed the keyword to be specific

Post the changes maybe is something siple as a wildcard been needed