Filter by content of this user imported cell

[Anonymous321]

Hey

I'm wondering is its possible to set up a filter that filters a table by the content of a user imported cell rather than the user applying a filter by clicking the arrow and choosing an option from the dropdown box. For example in cell "b2" the user will have an option to pick a film genre, which ever they pick will filter the table in the same sheet below. Preferably I wouldn't want to use the Filter formula to to do this, but I understand that'll be the easiest option. I'm guessing VBA could be used but I'm not aware of how to accomplish this.

Any help will be appreciated, thanks.

 

[Anonymous321]

Update, managed to do this but only works when a button is clicked, would prefer it to be automatic

'Apply Filters to Column
If Range("N4").Value = "All" Then 'if All is select, don't apply any filters
Else:
    Worksheets("Sheet1").ListObjects("SecondDynamicTable1").Range.AutoFilter _
     Field:=13, _
     Criteria1:="=*" & Range("n4").Value & "*", Operator:=xlAnd, _
     VisibleDropDown:=True
End If