auto filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
Back
Top