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