Multiple Auto Filters ?

  • Thread starter Thread starter Steve Klenner
  • Start date Start date
S

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
 
try selecting the range for the 1st one so that it stops before the 2nd.
 
You can only have one AutoFilter per worksheet.

Steve said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - How to copy rows found & to cater if no rows found via autofilter 1
Two Totals from the same column 2
Excel Complex Summing 3
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Excel Macro to use cells as a autofilter 0
Setting a Filtered Range 7
Advanced Filter Error - I cannot spot my Error 3
Autofilter problem 7

Back
Top