Can I AutoFilter an entire workbook?

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

Guest

Can I AutoFilter an entire workbook? I have 12 worksheets each representing a
company I rep. The companies have crossover customers. If I wanted to see
sales for a particular customer I use AutoFilter on the worksheet and that's
good by each manufacture but how would I AutoFilter the entire workbook so I
could look at the total sales for that same customer?
 
Hi
not really possible with Excel. this sounds for me more like a database
application if you need several worksheets to store your data
 
You should try the lookup functions (vlookup, hlookup) which ever suits your
application.
 
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

autofilter with summary row 1
autofilter on open 7
Autofilter does not work on protected w/s even when "checked to allow" ?? 6
autofilter to last week by default 1
subtotals with custom autofiltering 1
Excel Macro to use cells as a autofilter 0
Autofilter 10
Auto-filter selection 1

Back
Top