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:

Sub LookForMe()

Dim strSearch As String
Dim cel As Range
Dim ws As Worksheet

strSearch = Application.InputBox("Enter term to look for")

Set ws = Worksheets.Add(, after:=Sheets(Sheets.Count))
ws.Name = strSearch

For Each cel In Me.UsedRange
    If InStr(1, cel.Value, strSearch) > 0 Then
        cel.EntireRow.Copy Destination:=ws.Range("A" & Rows.Count).End(xlUp).Offset(1)
    End If
Next cel
    
End Sub