| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adv. Filter - Want to copy to inactive sheet | Excel Discussion (Misc queries) | |||
| How do I email an inactive copy of a worksheet | Excel Discussion (Misc queries) | |||
| Copy/filter data in a sheet from another sheet | Excel Discussion (Misc queries) | |||
| 'Copy to' Advance Filter depend only on sheet ID not start sheet | Excel Worksheet Functions | |||
| DATA FILTER ARROWS DISPLAY WHILE INACTIVE | Excel Worksheet Functions | |||
Linear Mode
