Adv. Filter - Want to copy to inactive sheet

  • Thread starter Thread starter Maki
  • Start date Start date
M

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?
 
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
 
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...
 
Back
Top