Can I use advanced filter on multiple worksheets in one workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a number of worksheets in a workbook and I am trying to search each
worksheet simultaneously using the advanced filter.

However, once I have completed the advanced filter on one sheet, all other
sheets return null results.

Is this a bug or am I doing something wrong?
 
AFAIK you can only use the Advanced Filter on one sheet at a time. In fact,
if you group sheets, AutoFilter is grayed out.

tj
 
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

Advanced Filter 1
Single Filter to change all Pivot Tables in a Workbook 8
Auto Naming Worksheets 4
Bug in Advanced filter 1
Aligning Colour Scheme Across Workbook 0
consolidate workbooks to worksheets in one workbook? 1
Multiple workbooks to one worksheet 3
Hiding advanced filter 1

Back
Top