Greetings
I have a pivot table called "pt_UsagePS" as shown in the 1st graphic (upper right).
Basically, If the user selects "74062 - FST FD/SNK BAR (cellT8)" from the combo box to follow, I want to store the "Row_ID (cell S8) for later use.
As you can see at cell B15, I store the results of the user's selection.
As you see, the combobox is displaying the four-items correctly from the "filtered pivot table"
This is how I accomplished it in vba (with your prior help of course).
Set PvtTbl = Worksheets("AdminCtrls").PivotTables("pt_UsagePS") 'Set creates an Object
With PvtTbl
.PivotFields("Facility Number").ClearLabelFilters
.PivotFields("Facility Number").PivotFilters.Add Type:=xlCaptionEquals, Value1:=myfilter2
End With
Finally, How do I select the "Row_ID in vba so I can store it? Thanks.