Hi All,
I need a bit of help. I have a report where i want to filter 2 pivot tables from one selection. I found a bit of code on the internet which allows me to do it, but just realised that it doesn't work when "Select Multiple Items" is selected in the pivot selection.
This is the code i'm using at the moment. is there a better way to do this? i need to be able to select 2 regions (like scotland and South East) at the same time across 2 pivots.
I need a bit of help. I have a report where i want to filter 2 pivot tables from one selection. I found a bit of code on the internet which allows me to do it, but just realised that it doesn't work when "Select Multiple Items" is selected in the pivot selection.
This is the code i'm using at the moment. is there a better way to do this? i need to be able to select 2 regions (like scotland and South East) at the same time across 2 pivots.
Code:
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Dim PT As PivotTable
On Error GoTo ExitPoint
Application.EnableEvents = False
For Each PT In ActiveSheet.PivotTables
If PT <> Target Then PT.PageFields("Region").CurrentPage = Target.PivotFields("Region").CurrentPage.Value
Next PT
ExitPoint:
Application.EnableEvents = True
End Sub
