Single selection for multiple pivot tables vba

[kev_33]

Hi All,

Sorry if I'm repeating an already reported question, but haven't found anything on the web and any help would be appreciated!

I have two sets of data, which I cannot combine into one as they are at different levels. But they have a common column - Month. If I have two pivot tables (one from each of these data sets) with month in the Report Filter, how can I get it such that if the user selects January in the first pivot, it automatically selects January as the month in the second pivot as well?

I used a worksheet_change event, but that didn't work out at all, probably coz of my coding skills Can someone provide correct code or another way to solve this issue?...thanx in advance!

[Cheeky Charlie]

Try something like this in the workbook code:

Please Login or Register  to view this content.

You will need to adjust for sheet names, pagefield name etc.

[kev_33]

Thanx CC for your assistance, but I had got my worksheet_change event code to work and I went along with that. But I'll test the above as well for future reference. Thanks once again

[Cheeky Charlie]

That's fine, it's your project.
I would only add that if you put the code (this, or an adjusted version of your own) in the workbook rather than the sheets you only need to maintain one set of code to trigger for either pivot change - the code itself is virtually identical regardless of location.