Thanks Dave

I dont suppose there is an Excel 2000 Add-in I can download that gives me
this feature? No? Oh well, I will start saving the pennies for XL2003 then!!

Thanks again

"Dave Peterson" wrote:

You get one range to filter per worksheet. That range can have multiple
columns, though.

xl2003 added a Data|List feature that looks a lot like data|filter|autofilter.
And you can have multiple lists per worksheet in xl2003+.



chris menzies wrote:

Hi All

I have an Excel 2000 workbook and I would like to have 2 Filters on the same
worksheet. Is this possible? When I highlight my selection and choose
Filter, it will just remove one filter and create a new one, thus not
allowing me to have the 2 on the same page.

I would be interested if this is just an Excel 2000 issue and whether later
versions (or though I dont own any!!!) allow you this option.

Thanks

--

Dave Peterson