Autofilter

  • Thread starter Thread starter Reijer
  • Start date Start date
R

Reijer

Hello Excellers,

I would like to apply an autofilter to multiple worksheets, the criteria for
the sheets are all the same. There are 3 sheets that don't need to have an
autofilter. How can i realise this. Do i have to hide the sheets that don't
need a autofilter and how do i apply the filter to the other sheets.

Thanks,

Reijer
 
I can only imagine that this would best be done one at a time by Macro, and
the filtered results copied from all the sheets over to one new sheet for
analysis.

Vaya con Dios,
Chuck, CABGx3
 
If your there are not too many data: Reference your data all on one sheet
(either by creating a dedicated sheet just for the purpose of autofilter, or
by adding references of data on sheets 2 and 3 beneath the data on sheet 1).
This gives you one (big) data table for your autofilter. You don't have to
do anything with the sheets that don't require an autofilter.

Cheers,

Joerg
 

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 count 1
Code to turn off autofilter 2
VBA: How can I use a string variable as autofilter criteria? 4
Sort-function of AutoFilter doesn't work, when sheet is protected 4
problem with a macro autofilter to delet rows 6
Excel VBA - How to copy rows found & to cater if no rows found via autofilter 1
autofilter results based on cell input 5
Excel Macro to use cells as a autofilter 0

Back
Top