Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic of Excel data
A table lists all products with sales for a period. I wish to filter that
list to only show the products that have a sales value. i.e. not products with no sales. Easy with a filter but... I want the resultant table (the filtered one) to update when a change is made in the primary table. I don't want to have to complete the data in the primary table and then filter the data to another location. Can this be done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Data Series Selection from Data Validation Dropdown? | Charts and Charting in Excel | |||
dynamic data range in pivot tables excel 2007 | Excel Discussion (Misc queries) | |||
Dynamic URL for first column of data from excel query? | Excel Discussion (Misc queries) | |||
Dynamic URL for first column of data from excel query? | Excel Discussion (Misc queries) | |||
dynamic chart on user selected data range in Excel 2007 | Charts and Charting in Excel |