Multiple listboxes to update pivot table?

C

Cam

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic link with 2 dependent listbox? 0
Help list box to update pivot table 1
Help with listbox from pivot table with dynamic data 0
Dealing with a Pivot Table (when I don't want to) 0
Slicers and Calculated Items in Pivot Table 2
Help with query multiple records into one 5
Additional columns for Pivot table 0
Pivot Tables and Filter Criteria Display 0

Top