I am trying to filter my results by a specific value in one of my columns: keyword. Headers are in 2nd row and data starts in row 3. I want to filter all results by a keyword search of column 2. Here are some sample rows:

Row 2 = [Col1 Header] [Col2 Header] [Col3 Header]

Row 3 = [Joan] [training,funding,curriculum] [2/20]
Row 4 = [Jane] [legislation,reports,time frame] [3/18]
Row 5 = [Jean] [fiscal,support,priority,training] [3/22]

I want to be able to enter a text string into cell A1 that filters results by searching in column 2. So, if I enter the string "training" in A1, the results will autofilter and display only the values from Row 3 and Row 5, because they contain the word "training." I found a similar VBA script, but it only worked if the search value matched entire cell contents. I need to filter if the cell CONTAINS the value, not EQUALS the value. Thanks!