Hello. I can't seem to get this to work. I have 5 fields that need to be auto filtered if they exists in the pivot table. How do I auto filter these if any of them exists in the pivot table? Thank you so much!
'
With ActiveSheet.PivotTables("PivotTable2").PivotFields("Check / Trace #")
.PivotItems("").Visible = False
.PivotItems("Invoice Cash Credit XFer (+)").Visible = False
.PivotItems("Invoice Cash Debit XFer (-)").Visible = False
.PivotItems("Invoice Non-Cash Credit XFer (+)").Visible = False
.PivotItems("Invoice Non-Cash Debit XFer (-)").Visible = False
End With
End Sub
Sub Macro6()
'
'
With ActiveSheet.PivotTables("PivotTable2").PivotFields("Check / Trace #")
.PivotItems("").Visible = False
.PivotItems("Invoice Cash Credit XFer (+)").Visible = False
.PivotItems("Invoice Cash Debit XFer (-)").Visible = False
.PivotItems("Invoice Non-Cash Credit XFer (+)").Visible = False
.PivotItems("Invoice Non-Cash Debit XFer (-)").Visible = False
End With
End Sub
Sub Macro6()
'