VBA Filtering Columns based on Cell Value for multiple columns

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!

hi MikeRoot, option, please check attachment, enter value in H1 on Sheet1

Hi PCI and Watersev,

Thank you both for your suggestions, both really helpful! And achieve what I want them to.

Amazing work, you've saved me a lot of work! Thank you!

Mike

Hi guys,

I appreciate the help - really is exactly what I was after!

I was wondering if it is possible to adapt it so that any values that are less than the input threshold (H1) would be return at "<H1 Value"? Currently, I am using Watersev's code, so adaptions to that would be amazing!

Thanks for the help - this would be an added bonus and would eliminate a further formula step

Thanks!

Mike

Hi PCI,

I appreciate your patience. Ideally I am looking for about output of a table displays all the values great than H1, but all the values within the table that are less H1 rather than displaying their actual value to simply display <"H1" (whatever the value of H1 is).

Apologies about the lack of clarity!

Mike

Hi PCI,

Great point! Don't think I have fully thought this through as you're right I'd lose the data, then if I then changed the value in H1 it would need to update based on the overwritten data.

Not to worry! Thanks for your help really appreciated and as I said the main problem I had has been resolved.

Thanks,

Mike