No, you will have to copy to the activesheet and then a seond copy of the
data to the next sheet
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Maki" wrote:

When you use Advanced Filter to copy the outcome to another location, Excel
would only let you copy to the same (active) worksheet.

Is there a way to get around this and copy to another sheet?
--
Maki @ Canberra.AU