DataList sets up separate tables on a sheet.

Each table has its own autofilter.

Did you try it if you have Excel 2003 or 2007?


Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 12:54:01 -0700, Janis
wrote:

No, data/list-I do not need it. I need a number of auto filters in one sheet!

"Dave Peterson" wrote:

If you're using xl2003, you may want to look at Data|List.

xl2007 has the equivalent (I _think_ it changed names, though).

Personally, I like to put different tables on different sheets. I think
segregating the data is a good idea--for the most part.