Automatically update pivot report filter

I want the value in a pivot report filter to be the same as a value in a cell on another sheet. When the value on the other sheet changes I want the value of the report filter to change to match this value.

I have some code (from the web) that works, but only if you click on the sheet that has the pivot table in it. I want the pivot table to update without having to click on the sheet.

Code is as follows:

Please Login or Register  to view this content.

Any help would be greatly appreciated. Thanks.

Many thanks for your assistance Dave. Unfortunately the code did not work (in fact even my old code isn't working now). I have attached a file which shows what I'm trying to do. I think the use of the combo box may be complicating things.