Hector,

The code seems to be working correctly. I also have a graph that is based
off of the two tables.

Whenever I change the Month the columns will change in both tables, but the
graph will flicker on and off until Excel closes.

any ideas?


"Héctor Miguel" wrote:

hi, samuel !

Sorry, I'm new to VBA, and I'm not following your suggestion.

- right-click on your worksheet tab/name (where your PT resides) and choose "view code"

- copy/paste the proposed code into "that" code module window:
(if necessary, replace whatever lines on it, assuming you are not using any other code)

Private Sub Worksheet_Calculate()
Me.PivotTables("PivotTable5").PivotFields("Facilit y").CurrentPage = _
CStr(Me.PivotTables("PivotTable4").PivotFields("Fa cility").CurrentPage.Value)
End Sub

give it a try by changing your PT4 field ("Facility") and see what happens on your PT5

hth,
hector.