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 =...