I would like to make the following work across two pivot tables on two different worksheets. I can get this to work when the pivots are on the same worksheets but not on separate ones. Do I need to add an array?
Option Explicit
Private Sub Worksheet_Change _
(ByVal Target As Range)
Dim ws...