Re: AutoFilter Question

[Debra Dalgleish]

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

ram wrote:
> 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
Contextures
http://www.contextures.com/tiptech.html

[ram]

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, ...

--

Dave Peterson

[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

[ram]

Thanks for the help

[ram]

Thanks for the help