VBA keyword search

Hi,

I have a list of 19,000 conferences in an excel file. These conferences range from everything medical, agriculture, IT, science, legal, etc. I need to only produce a list of conferences that cover the mining industry.

Column A has the event Name
Column B has the corresponding website
Column F has the event description
Column G has the Event Production Company

Keywords to search for: Mining, mine, mining industry, etc

Is their a way with a formula or VBA to perform a search based on this list of conference names and descriptions, searching for particular keywords, and than after parsing through the entire list, produce a second list on another sheet of the properly identified events?

As a second layer of search is it possible, if not to complex, to either Google the event name or parse the linked webpage for similar keywords and add that to the final list?

Also I have attached demo data of the first 1,000 conferences.

International List.xlsx

Thank You

Maybe:

Please Login or Register  to view this content.