Advanced Filtering

Tony · Apr 28, 2005

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

Carole O · Apr 28, 2005

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

Alan · Apr 28, 2005

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 · Apr 29, 2005

Thanks Alan,

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

Tony