Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic link with 2 dependent listbox?
Hello,
I have a chart with sources coming from a pivot table. The filter fields are workcenter and machine. There can be multiple machines in a workcenter. On the chart sheet, I have two control listboxes, one for workcenter and one for machine selection. Once the workcenter listbox is selected it will filter in the pivot table, then in turn update the graph based on the pivot table data. The problem I dont know how to resolve is how the machine listbox is depending on the workcenter selection. When user selects a workcenter from the listbox, it will update the chart based on workcenter filter in the pivot table, but then I need the machine listbox to list only the machines that are in the selected workcenter. Finally, if the user selects a machine from the machine listbox, it will filter the machine also in addition to the workcenter. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation via Dependent List defined by Dynamic Range | Excel Discussion (Misc queries) | |||
Dynamic Dependent Dropdown - one question for Mr. Phillips | Excel Discussion (Misc queries) | |||
Dynamic Ranges using non-contiguous cells and dependent on a cell value | Excel Worksheet Functions | |||
dependent drop down boxes and dynamic ranges | Excel Worksheet Functions | |||
dynamic link | Links and Linking in Excel |