HORIZONTAL FILTER

[arnoldmiranda]

Hi,
Is it possible to write a macro which can enable me to create a horizontal filter in excel

rgds

 

[Jonmo1]

A bad idea is transposing your data to show vertically.

Why is that a bad idea?

I would say that's a very good idea.

 

[ausrunas]

Hi Erik,


How could I change Const FilterColumn=1 to look up the value in a cell A1?
I want to do that once macro is run it picks up the value to filter on, rather than 1.

Thank you
Aus


Const FilterColumn = 1 '1 is most logical value but you may change this