Advanced filter

[David B]

I get the following message when I try to use the "copy to
another location" option in the advanced filter box: "You
can only copy filtered data to the active sheet". How can
I get around that? I should be able to have the result of
my filter copied to another worksheet.
Thank you for your help.

David.

 

[Mike]

Say the source sheet has the database to be filtered.
Say the target sheet is to have the result.
At first have the target sheet active and start the job like [Data]-->[Filter]--> ...