Advanced Filtering

Is it possible using Advanced Filtering, to have the output go to a different
Sheet,
instead of the current sheet(database Sheet).

Thanks in advance.

Tony

In 2003, it asks (data, filter, advance filter) if the data should be copied
to another location. Don't know about other versions.

Carole O



"Tony" wrote:

> Is it possible using Advanced Filtering, to have the output go to a different
> Sheet,
> instead of the current sheet(database Sheet).
>
> Thanks in advance.
>
> Tony

Yes you can, but you need to start the filter on the destination sheet and
browse back to the data range you want to filter,
Regards,
"Tony" <Tony@discussions.microsoft.com> wrote in message
news:32473475-BBB6-4877-B3D2-3EDC80FDB192@microsoft.com...
> Is it possible using Advanced Filtering, to have the output go to a
> different
> Sheet,
> instead of the current sheet(database Sheet).
>
> Thanks in advance.
>
> Tony

Thanks Alan,

It worked like you said and it is exactly what I needed.

Tony

"Alan" wrote:

> Yes you can, but you need to start the filter on the destination sheet and
> browse back to the data range you want to filter,
> Regards,
> "Tony" <Tony@discussions.microsoft.com> wrote in message
> news:32473475-BBB6-4877-B3D2-3EDC80FDB192@microsoft.com...
> > Is it possible using Advanced Filtering, to have the output go to a
> > different
> > Sheet,
> > instead of the current sheet(database Sheet).
> >
> > Thanks in advance.
> >
> > Tony
>
>
>