Macro for a Pivot Table selection

[nilsan7]

Hi there, I have a simple question. On a worksheet, I have 2 Pivot Tables looking at the same data. I would like the user to select an item in Table1 and the Table2 should also use that same option. How do I write a macro for that? So what I mean is, let us say the user has to select a city and there are 10 cities, s/he chooses AUCKLAND in the PivotTable1 under CITY and the same should be selected automatically in PivotTable2 under CITY. I have 2 charts linked to these 2 Tables which will update automatically so all I want is the user to select it once. Can you please help me? Thanks

 

[Marcelo Branco]

I checked again and the new code works now - thanks Marcelo

Great!

M.