Hello,
I have the following fields I would like to add as values in a pivot table: 1001000, 1001010, 1001020, 1001030, 1001040, 1001050 . . . 1001820. I am familiar with the VBA code to simultaneously add all of your fields as values. However, I am creating multiple pivot tables from the same source data and only want to add smaller, consecutive portions of the fields for each separate pivot table. As an example, the first pivot table uses 1001000 through 1001200, and the second pivot table uses 1001210 through 1001400. Is there a way to do this in VBA?
Thank you.
I have the following fields I would like to add as values in a pivot table: 1001000, 1001010, 1001020, 1001030, 1001040, 1001050 . . . 1001820. I am familiar with the VBA code to simultaneously add all of your fields as values. However, I am creating multiple pivot tables from the same source data and only want to add smaller, consecutive portions of the fields for each separate pivot table. As an example, the first pivot table uses 1001000 through 1001200, and the second pivot table uses 1001210 through 1001400. Is there a way to do this in VBA?
Thank you.