Start the filter operation from the destination sheet. If the data to filter
is on Sheet1 and you want the filtered data to be copied to Sheet2, start
the filter process from Sheet2.

--
Biff
Microsoft Excel MVP


"Maki" wrote in message
...
Hi

Is there a way to get around Excel not being able to copy the advanced
filter results to other than current worksheet?

Thank you.
--
Maki @ Canberra.AU