Multiple listboxes to update pivot table?




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