Multiple Use Of Auto Filter

  • Thread starter Thread starter paulmoles
  • Start date Start date
P

paulmoles

Is it possible in Excel Xp to use Auto Filter more than
once on ONE worksheet?
I have a worksheet containing several named ranges and
wish to AutoFilter each range separately.

I do not want to use seperate sheets as the combined
information is then difficult to see. (The Ranges are not
formula linked.).
Many Thanks
Paul Moles
 
No, you can only have one AutoFilter per worksheet. Perhaps you could
store the data on separate sheets, then open another window in the
workbook (Window>New), and tile the windows (Window>Arrange) to see both
 

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

Using Autofilter More Than Once 3
using autofilter data 2
auto filters and worksheet protection 3
VBA: How can I use a string variable as autofilter criteria? 4
Auto Filter & Display 2
Macro to copy value in field and insert it into filter 2
sum of visable cells in filtered range 7
Auto Filter Multiple Criteria 1

Back
Top