Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remote Filtering
How to i move a list filter from the top of the list to another sheet.
i.e. i want a "front sheet" with various filters which will filter the data on another sheet and display a total from the list after it has been filtered. thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remote Filtering
You can start an Advanced Filter from the destination sheet, and refer
to the source list on the first sheet. There are sample files he http://www.contextures.com/excelfiles.html Under Filters, look for Product List by Category wrote: How to i move a list filter from the top of the list to another sheet. i.e. i want a "front sheet" with various filters which will filter the data on another sheet and display a total from the list after it has been filtered. thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remote References | Excel Discussion (Misc queries) | |||
Advance filtering with multiple conditons | Excel Discussion (Misc queries) | |||
filtering | Excel Discussion (Misc queries) | |||
Row filtering based on input box entry (column heading) | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |