wookieking
New Member
- Joined
- Nov 7, 2017
- Messages
- 1
I have a workbook with about 30 tabs that each have 6 PivotCharts. Each PivotChart has 12 PivotFields (Values) corresponding to the months of the year. These are basically creating a rolling year effect after data is updated. To do this effect, I need to take the PivotField in .Position = 1 and change it to .Position = 12 each time the macro is run.
I obviously can't use .PivotTables("xyz").PivotFields("Nov") because the top won't always be "Nov". I don't want to make the field name dependent upon when the macro is run because it might not be run in the correct month causing the months to be out of order and/or not being reflective of when the report actually should have been run.
Everything I've found doesn't tell me how to grab the name value of field 1. Lots of stuff telling me how to get the position value of a hard coded name, though.
Any help is appreciated.
I obviously can't use .PivotTables("xyz").PivotFields("Nov") because the top won't always be "Nov". I don't want to make the field name dependent upon when the macro is run because it might not be run in the correct month causing the months to be out of order and/or not being reflective of when the report actually should have been run.
Everything I've found doesn't tell me how to grab the name value of field 1. Lots of stuff telling me how to get the position value of a hard coded name, though.
Any help is appreciated.
