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