I have Pivot Table I have created through a macro. Now what I want to do is create a macro to open and show the detail of each grand total result for each technician.
The number of technicians can change., but the technician row is always in the same spot. But the grand total row can change, does not always stay the same.
I was able to record the below code but know that will not work for the criteria I outlined above. Also see attached picture for the pivot table.
The number of technicians can change., but the technician row is always in the same spot. But the grand total row can change, does not always stay the same.
I was able to record the below code but know that will not work for the criteria I outlined above. Also see attached picture for the pivot table.
VBA Code:
Sub Macro2()
'
Range("B23").Select
Selection.ShowDetail = True
Sheets("PivotTable").Select
Range("C23").Select
Selection.ShowDetail = True
Sheets("PivotTable").Select
Range("D23").Select
Selection.ShowDetail = True
Sheets("PivotTable").Select
Range("E23").Select
Selection.ShowDetail = True
Sheets("PivotTable").Select
Range("F23").Select
Selection.ShowDetail = True
End Sub