jakeman
Active Member
- Joined
- Apr 29, 2008
- Messages
- 325
- Office Version
- 365
- Platform
- Windows
I have a pivot table that I would like to try to filter based upon values from a list on another worksheet, using VBA.
the pivot table is on a worksheet called Sheets("temp_UtilPivot") and the name of the pivot table is temp_UtilData_pivot.
The field in the pivot table is called PCP_Name and the list that I want the PCP_Name field to be filtered off of is on the sheet called Sheets("Lists") and the range of values is stored as a named range = PCP_Selections. PCP_Selections is a dynamic named range that changes in size based upon values added.
I'm using Excel 2010.
thanks.
the pivot table is on a worksheet called Sheets("temp_UtilPivot") and the name of the pivot table is temp_UtilData_pivot.
The field in the pivot table is called PCP_Name and the list that I want the PCP_Name field to be filtered off of is on the sheet called Sheets("Lists") and the range of values is stored as a named range = PCP_Selections. PCP_Selections is a dynamic named range that changes in size based upon values added.
I'm using Excel 2010.
thanks.