Multiple Auto Filters ?

[Steve Klenner]

Is it possible to have 2 autofilters for 2 different ranges in a single
worksheet?

Autofilter #1 = Rows 1-100
Autofilter #2 = Rows 300-500

If it can...how do you do it?.......it seems like when I create the 2nd one
the first one becomes disabled.

Steve

 

[Don Guillett]

try selecting the range for the 1st one so that it stops before the 2nd.

 

[Debra Dalgleish]

You can only have one AutoFilter per worksheet.

Is it possible to have 2 autofilters for 2 different ranges in a single
worksheet?

Autofilter #1 = Rows 1-100
Autofilter #2 = Rows 300-500

If it can...how do you do it?.......it seems like when I create the 2nd one
the first one becomes disabled.

Steve

 

[Dave Hawley]

Hi Steve

<<Is it possible to have 2 autofilters for 2 different ranges in a
single
worksheet?>>

Afraid not. Can you tell use your needs? Perhaps someone can help.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****