I am trying to update apivot table filter with a combo box on another sheet. When it is changed I use a macro to fire off the code. Here is the code. Can anyone help?
Please Login or Register to view this content.
I am trying to update apivot table filter with a combo box on another sheet. When it is changed I use a macro to fire off the code. Here is the code. Can anyone help?
Please Login or Register to view this content.
Hi Ethan05 and welcome to the forum,
I've created 3 pivot tables on the same sheet that will all filter based on changing only one of them. See if the code behind the attached helps you solve your problem.
If you want a better answer you should include a sample workbook.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks