AutoFilter Question

[Guest]

Hello All,


Is there a way to use AutoFilter for columns?

I have dates going across the top of my sheet , and would like to have an
AutoFilter button in column A that would filter the columns based on the date
I select from row 1.

Thanks for any help

Thanks for any help

Ramone

 

[Debra Dalgleish]

There's nothing built into Excel that will filter columns, instead of
rows. You could create a macro to hide the columns.

 

[Guest]

Thanks Debra,

Do you know where I could find code thatfilters by column?

Thanks

 

[Dave Peterson]

Record a macro when you hide one set of columns. Then record another macro when
you show all the columns. And record a macro when you hide the second set of
columns, then the 3rd set, ...

 

[Debra Dalgleish]

And to mark the columns to it's easier to hide them, you can use the
technique in the sample workbook here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for DV0045 - Hide Matching Columns

 

[Guest]

Thanks for the help

Record a macro when you hide one set of columns. Then record another macro when
you show all the columns. And record a macro when you hide the second set of
columns, then the 3rd set, ...

 

[Guest]

Thanks for the help

And to mark the columns to it's easier to hide them, you can use the
technique in the sample workbook here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for DV0045 - Hide Matching Columns