Adv. Filter - Want to copy to inactive sheet

[Maki]

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?

 

[Mike H]

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.

 

[מיכ×ל (מיקי) ×בידן]

Start the whole Sorting procedure from the TARGET Sheet.
Micky

 

[מיכ×ל (מיקי) ×בידן]

You may want to check and adopt my suggestion...
Micky

 

[Maki]

Wow, that's a true egg of Columbus!

Thank you, Micky!

 

[מיכ×ל (מיקי) ×בידן]

You're most welcome.

Wow, that's a true egg of Columbus!

Thank you, Micky!

 

[Mike H]

Never too late to learn something new, Thanks.
--
Mike

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

 

[מיכ×ל (מיקי) ×בידן]

I can only state that I'm still learning new excel "secrets" every single day
- and while learning, I realize how little I know...