Using Filters in Excel 2000

[Guest]

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]

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+.

 

[Guest]

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]

Nope.

You could write your own macro that would remove the data|filter from one range
and then reapply it to another range whenever you change selection, though.

And you may want to start saving for xl2007. Or visit eBay for older
versions????

 

[Debra Dalgleish]

Another option might be to select all the columns, in both tables, and
the blank columns in between.
Then, turn on the Autofilter, so both tables are included.
Filter any column in either of the tables.

Nope.

You could write your own macro that would remove the data|filter from one range
and then reapply it to another range whenever you change selection, though.

And you may want to start saving for xl2007. Or visit eBay for older
versions????

 

[Dave Peterson]

Good idea, but the headers for each table have to be in the same row.

And filtering one table will hide/show rows in the other table(s).

But if that's ok, you could use code at Debra's site to hide those arrows on
cells that are in empty columns:

http://contextures.com/xlautofilter03.html#Hide