auto filter
 

Does anybody know if it's possible to put 2 autofilters in one sheet?
At this moment I have them seperated in two sheets, but I have to switch the
whole time.

auto filter
 

In excel versions up to xl2002 (XP), I believe one autofilter per sheet was
the limit. Excel 2003 added a LIST construct/concept which includes an
autofilter. I don't know if you can put more than one on a sheet or not.

--
Regards,
Tom Ogilvy

"minostrada" wrote in message
...
Does anybody know if it's possible to put 2 autofilters in one sheet?
At this moment I have them seperated in two sheets, but I have to switch
the
whole time.

auto filter
 

I just tried it and you can have multiple lists per worksheet in xl2003.

To the OP: You have another response to your post in .excel.

Tom Ogilvy wrote:

In excel versions up to xl2002 (XP), I believe one autofilter per sheet was
the limit. Excel 2003 added a LIST construct/concept which includes an
autofilter. I don't know if you can put more than one on a sheet or not.

--
Regards,
Tom Ogilvy

"minostrada" wrote in message
...
Does anybody know if it's possible to put 2 autofilters in one sheet?
At this moment I have them seperated in two sheets, but I have to switch
the
whole time.


--

Dave Peterson