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

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.

--
Regards

Roger Govier


"Laurent" wrote in message
...
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

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



"Roger Govier" wrote:

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.

--
Regards

Roger Govier

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.

"Laurent" wrote:
.. 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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Maybe you can use Data|Group and outline

And group the columns instead of filtering.

Yep. It's not the same.

Laurent wrote:

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

--

Dave Peterson

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