Advanced Filter

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

Guest

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?
 
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?
 
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 Highlighting duplicates 0
Single Filter to change all Pivot Tables in a Workbook 8
Can I use advanced filter on multiple worksheets in one workbook? 1
Need to merge worksheets - Excel 2003 0
Aligning Colour Scheme Across Workbook 0
Require formula to search across multiple worksheets 2
Creating A List of Items Between Two Numbers 2
EXCEL FILTERS AND CHARTS 2

Back
Top