VBA Filtering Columns based on Cell Value for multiple columns

[MikeRoot]

Hi forum,

I am trying to use VBA to filter the example data attached based on an input value. I have found some code to filter a table using a cell value that only applies to one column, but I need the input value to apply to a range of columns. In the example, I have columns for Q1, Q2, Q3, Q4 sales. I would like to input a value into e.g. cell H1 = 200, then the VBA will filter the table pulling through only the rows of data where in at least one instance (in either Q1, Q2, Q3, Q4) the sales of that particular person was greater than 200. So the value needs to apply to more than one column.

Any help would be appreciated!

Thanks!