Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help list box to update pivot table
Hello,
I have a listbox that when selected, update the pivot table (change the variable pivot field called "Machine") based on the selection on the listbox. This part is working great. But I also have another variable field called "Workcenter" that would like to filter into the pivot, but don't know how. On the pivot table, there are multiple machines in a Workcenter. What I want is when I select the workcenter, it pivot the data for the selected workcenter, but I also select the machine number, it also filter the pivot table based on both the workcenter and machine. How do I make this in a Listbox option. All I can think of is create another listbox for Workcenter, but don't know the code to tie all this into the pivot table. Thanks for any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help list box to update pivot table
see response to your other posting
-- Regards Roger Govier "Cam" wrote in message ... Hello, I have a listbox that when selected, update the pivot table (change the variable pivot field called "Machine") based on the selection on the listbox. This part is working great. But I also have another variable field called "Workcenter" that would like to filter into the pivot, but don't know how. On the pivot table, there are multiple machines in a Workcenter. What I want is when I select the workcenter, it pivot the data for the selected workcenter, but I also select the machine number, it also filter the pivot table based on both the workcenter and machine. How do I make this in a Listbox option. All I can think of is create another listbox for Workcenter, but don't know the code to tie all this into the pivot table. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Update | Excel Discussion (Misc queries) | |||
Pivot Table update | Excel Discussion (Misc queries) | |||
VBA to Update Pivot Table | Excel Programming | |||
Pivot Table Update | Excel Discussion (Misc queries) | |||
Pivot Table update | Excel Discussion (Misc queries) |