Advanced Filter

  • Thread starter Duncan McDermott
  • Start date
D

Duncan McDermott

I have a workbook with numerous worksheets containing different data but
using the same headings each time. When trying to use the Advanced Filter to
search in each worksheet at the same time, the first worksheet works fine but
subsequently I get null results in other worksheets.

Can I simultaneously search multiple worksheets (for the same criteria) at
the same time?
 
J

Jim Rech

Can I simultaneously search multiple worksheets (for the same criteria) at
the same time?

I don't think so. Each Advanced Filter is independent of any others. Of
course with a macro you could fire off a series of AF that would effectively
be simultaneous.

--
Jim Rech
Excel MVP
message |I have a workbook with numerous worksheets containing different data but
| using the same headings each time. When trying to use the Advanced Filter
to
| search in each worksheet at the same time, the first worksheet works fine
but
| subsequently I get null results in other worksheets.
|
| Can I simultaneously search multiple worksheets (for the same criteria) at
| the same time?
 
Top