Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced filter to another sheet
I'm trying to filter a list following to fulfill a few criteria. Although I
could use Advanced filter but however i couldn't filter it to another sheet in the same workbook. Any other suggestion how I could do it so that data could be automatically updated from the first sheet, if it change? I couldn't seems to be able to use microsoft queries in the same workbook too. please advice. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced filter to another sheet
You can extract the data to another worksheet if you start the filter
from the destination sheet. There are instructions he http://www.contextures.com/xladvfilter01.html#ExtractWs goayimm wrote: I'm trying to filter a list following to fulfill a few criteria. Although I could use Advanced filter but however i couldn't filter it to another sheet in the same workbook. Any other suggestion how I could do it so that data could be automatically updated from the first sheet, if it change? I couldn't seems to be able to use microsoft queries in the same workbook too. please advice. Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help wanted for Advanced filter/sheet protection | Excel Worksheet Functions | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
Advanced Filter w/ multiple sheet List Range | Excel Worksheet Functions | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |