Hi,

Is there a way that I can add different sets of filters into the same
worksheet? For example, I have two seperate tables which I'd like to be able
to filter on simultaneously.

Thanks in advance as always

You get one range per worksheet when you filter.

You could remove a filter and apply elsewhere.

If you're using xl2003+, you may want to look at Data|List. It looks very
similar to data|filter, but you can have multiple ranges converted to lists.

Personally, if I have disparate data, I try to put it on different worksheets.
It makes things lots easier.

sam wrote:

Hi,

Is there a way that I can add different sets of filters into the same
worksheet? For example, I have two seperate tables which I'd like to be able
to filter on simultaneously.

Thanks in advance as always

--

Dave Peterson