Using vba to change pivot table filter based on cell value in another worksheet

Hi All,

First post here. I have posted a similar problem on the mrexcel forum which can be found here....

http://www.mrexcel.com/forum/excel-q...ell-value.html

What I am trying to achieve is to automatically update a pivot table ("PivotTable 3 which is in a sheet called "T5") based on cell D2 in a sheet called "Report". The only values that will appear in D2 will be the numbers 1-13, with the pivot table filter containing the same, so for example when I change the value in D2 to 1, I'd like the pivot table filter to change to 1.

Can anyone help with this? My knowledge of VBA isn't that good (still learning!) so any help would be greatly appreciated!!!

Hi All,

I've found a solution to this that was so simple can't believe I missed it!!!

Please Login or Register  to view this content.