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

  • Thread starter Duncan McDermott
  • Start date
D

Duncan McDermott

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?
 
T

tjtjjtjt

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
 
Top