Hi
This is what I currently have:
I want the red row to reference 'DATA INPUTS'!P6.....any ideas?![]()
Sheets("PLOC Previous 12 months").Select Range("A3").Select With ActiveSheet.PivotTables("PLOC_12Months").PivotFields("Graph solution") .PivotItems(Range("p6").Text).Visible = False End With Sheets("DATA INPUTS").Select Range("C7").Select End Sub
Thanks for the help
Wil
Bookmarks