Horizontal filtering

Hi,

I need a VBA to do some sort of horiztonal filter in Excel. I assume the only real way of doing this is by hiding columns which is fine.

The code needs to read the input from F1 and hide any columns where this input does not appear in cell 1 of that column i.e. only leave the columns which match the corresponding input.

- Please only hide columns from G onwards (the code needs to read to the end of the non blank columns as I need to keep adding data columns)

See screenshot below - in this instance the input is "GCM" in F1 so columns H, I and J would need to be hidden but columns K and L would remain visible.

Thanks

Jack
Capture1.JPG

Something like:

Please Login or Register  to view this content.