Updating a pivot table filter from a combo box on another sheet

[Ethan05]

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.

[MarvinP]

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.