How do I add multiple filters

S

sam

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
 
D

Dave Peterson

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