This currently is attached to a field and when it changes to a name it updates the pivot tables written in it, it only changes the filters, how can I have it change the row filter instead of the master filter?
Set pt = Worksheets("TPPE Summary Level").PivotTables("VLQP")
Set Field = pt.PivotFields("EVM Name")
NewCat = Worksheets("TPPE Summary Level").Range("C6").Value
'This updates and refreshes the PIVOT table
With Field
.ClearAllFilters
On Error Resume Next
.CurrentPage = NewCat
End With
Set pt = Worksheets("TPPE Summary Level").PivotTables("VLQP")
Set Field = pt.PivotFields("EVM Name")
NewCat = Worksheets("TPPE Summary Level").Range("C6").Value
'This updates and refreshes the PIVOT table
With Field
.ClearAllFilters
On Error Resume Next
.CurrentPage = NewCat
End With
