Autofilter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Reijer - 08 Jan 2007 21:05 GMT

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

Reply to this Message

CLR - 09 Jan 2007 00:29 GMT

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

> Hello Excellers,
>
[quoted text clipped - 6 lines]
>
> Reijer

Reply to this Message

Joerg - 09 Jan 2007 04:13 GMT

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

> Hello Excellers,
>
[quoted text clipped - 6 lines]
>
> Reijer

Reply to this Message