Autofilter on rows instead of columns

[Laurent]

Hi all !

I use Excel 2002 and I'd like to use the 'autofilter' function ('Data' menu
-> filter -> autofilter) but instead of sorting on criterias by columns, I'd
like to sort on rows (my sheet has the criterias on the side rather than on
the top !)

Thanks for help !

Laurent

 

[Roger Govier]

Hi

I think you have it the wrong way round. Filter normally Filters by row,
with the criteria in the top row of the set of data to be filtered.

You are wishing to Filter / Hide columns across the sheet base upon
criteria in the first column.
There is no built in method for doing this.
Debra Dalgleish has a simple workbook with some code to achieve this on
her site at

http://www.contextures.com/AdvFilterStateNum.zip

Here the criteria are still set in the top row, so you could either copy
your criteria to the first row, or amend the code.

 

[Laurent]

Thanks a lot.
I studied the code of the macro ; Debra use the advanced filter function. I
will try to understand this function that I failed to run correctly...

Thanks again

Regards

Laurent Fessy

 

[Laurent]

I've learned about the advanced filter function through excel's help, and
indeed it can only filter on lines. It seems unbelievable not to be able to
filter on columns !...

I guess what I got to do is to reverse my tab...

If anyone has an idea, please let me know. Thanks.

 

[Dave Peterson]

Maybe you can use Data|Group and outline

And group the columns instead of filtering.

Yep. It's not the same.

 

[Max]

.. filter on columns !...

Another thought .. Try Andrew Engwirda's page at:
http://blog.livedoor.jp/andrewe/archives/50283818.html
with a d/l link for a sample file on the page
(Horizontal Filter)

 

[Laurent]

Max, Dave, I thank you both.

Max has the very answer to my question. The macro works great, I gotta
browse the code to understand it fully.
Dave, I did not know this function, so thank you also !

Regards,

Laurent Fessy