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

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

Thanks Debra,

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

Thanks



"Debra Dalgleish" wrote:

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

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



ram wrote:

Thanks Debra,

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

Thanks

"Debra Dalgleish" wrote:

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



--

Dave Peterson

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

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

Under Data Validation, look for DV0045 - Hide Matching Columns

Dave Peterson wrote:
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, ...



ram wrote:

Thanks Debra,

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

Thanks

"Debra Dalgleish" wrote:


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






--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thanks for the help


"Dave Peterson" wrote:

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



ram wrote:

Thanks Debra,

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

Thanks

"Debra Dalgleish" wrote:

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



--

Dave Peterson

Thanks for the help


"Debra Dalgleish" wrote:

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

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

Under Data Validation, look for DV0045 - Hide Matching Columns

Dave Peterson wrote:
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, ...



ram wrote:

Thanks Debra,

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

Thanks

"Debra Dalgleish" wrote:


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






--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html