Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter in Excell
In excell, I use (Data,Filter,Advanced) to extract filtered data from a list
and copy it to another location, but up until now only on one sheet, no problem, but now need to same operation from larger database. Can anyone show me how to use this "ADVANCED FILTER" using a "List Range" that extends across multiple Sheets in the same workbook? Dugout Doug |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter in Excell
I do not believe this can be done. If we knew the exact layout of your file,
a little code could do it. Otherwise your better off in Access or you'll have to run the Advanced Filter on each sheet, and put the results on a new sheet, then run the Advanced Filter on that sheet.... "Dougout Doug" wrote: In excell, I use (Data,Filter,Advanced) to extract filtered data from a list and copy it to another location, but up until now only on one sheet, no problem, but now need to same operation from larger database. Can anyone show me how to use this "ADVANCED FILTER" using a "List Range" that extends across multiple Sheets in the same workbook? Dugout Doug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter not working | Excel Worksheet Functions | |||
Hiding advanced filter | Excel Discussion (Misc queries) | |||
Refresh advanced filter | Excel Discussion (Misc queries) | |||
advanced filter | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |