I have three pivot tables on the same worksheet. Is it possible that if I select Janauary data on one pivot table, the other two pivot table will automaticlly show the January data as well? Currently I need to select January data for all three pivot tables in order to do the comparison. Please adivse.

I saw some posts in another forum about similar issue. Some people were talking about using PivotTableUpdate(See below). I am not familiar with those, but I am going to pick up some books at barnes and nobles to learn.

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

    Application.EnableEvents = False

    Dim pt As PivotTable

    For Each pt In ActiveSheet.PivotTables
        pt.PivotFields("month").CurrentPage = Target.PivotFields("month").CurrentPage.Name
    Next pt

    Application.EnableEvents = True

End Sub

that is how you would do it if the pivot tables were on the same sheet