Hello,
I'm not proficient with VBA and would like some help with a recurring stumbling block.
Is there a way to have Excel read in a list of values and then select those values from a pivot table field? The list and the pivot are on separate worksheets in the same workbook.
The list of values is usually the result of some other manipulations. I want to be able to go back to a pivot table and have those values selected programmatically because the list can have 100 or more items.
(Excel 2003)
I'm not proficient with VBA and would like some help with a recurring stumbling block.
Is there a way to have Excel read in a list of values and then select those values from a pivot table field? The list and the pivot are on separate worksheets in the same workbook.
The list of values is usually the result of some other manipulations. I want to be able to go back to a pivot table and have those values selected programmatically because the list can have 100 or more items.
(Excel 2003)