Adv. Filter - Want to copy to inactive sheet
 

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

Adv. Filter - Want to copy to inactive 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.


"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

Adv. Filter - Want to copy to inactive sheet
 

Start the whole Sorting procedure from the TARGET Sheet.
Micky


"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

Adv. Filter - Want to copy to inactive sheet
 

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


"Mike H" wrote:

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

Adv. Filter - Want to copy to inactive sheet
 

Wow, that's a true egg of Columbus!

Thank you, Micky!
--
Maki @ Canberra.AU


"מיכאל (מיקי) אבידן" wrote:

Start the whole Sorting procedure from the TARGET Sheet.
Micky


"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

Adv. Filter - Want to copy to inactive sheet
 

You're most welcome.


"Maki" wrote:

Wow, that's a true egg of Columbus!

Thank you, Micky!
--
Maki @ Canberra.AU


"מיכאל (מיקי) אבידן" wrote:

Start the whole Sorting procedure from the TARGET Sheet.
Micky


"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

Adv. Filter - Want to copy to inactive sheet
 

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.


"מיכאל (מיקי) אבידן" wrote:

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


"Mike H" wrote:

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

Adv. Filter - Want to copy to inactive sheet
 

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


"Mike H" wrote:

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.


"מיכאל (מיקי) אבידן" wrote:

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


"Mike H" wrote:

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