Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Advanced Filtering
Is it possible using Advanced Filtering, to have the output go to a different
Sheet, instead of the current sheet(database Sheet). Thanks in advance. Tony |
#2
|
|||
|
|||
In 2003, it asks (data, filter, advance filter) if the data should be copied
to another location. Don't know about other versions. Carole O "Tony" wrote: Is it possible using Advanced Filtering, to have the output go to a different Sheet, instead of the current sheet(database Sheet). Thanks in advance. Tony |
#3
|
|||
|
|||
Yes you can, but you need to start the filter on the destination sheet and
browse back to the data range you want to filter, Regards, "Tony" wrote in message ... Is it possible using Advanced Filtering, to have the output go to a different Sheet, instead of the current sheet(database Sheet). Thanks in advance. Tony |
#4
|
|||
|
|||
Thanks Alan,
It worked like you said and it is exactly what I needed. Tony "Alan" wrote: Yes you can, but you need to start the filter on the destination sheet and browse back to the data range you want to filter, Regards, "Tony" wrote in message ... Is it possible using Advanced Filtering, to have the output go to a different Sheet, instead of the current sheet(database Sheet). Thanks in advance. Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filtering - Computed Criteria | Excel Worksheet Functions | |||
avanced filtering for latest date | Excel Discussion (Misc queries) | |||
Case sensitive advanced filtering | Excel Discussion (Misc queries) | |||
Advanced Filter using Date represented as text | Excel Worksheet Functions | |||
extracting numbers with no more than 8-digits using advanced filtering | Excel Worksheet Functions |