welshraz
New Member
- Joined
- Apr 29, 2016
- Messages
- 39
- Office Version
- 365
- Platform
- Windows
Hello,
I have a small pivot table with data on various UK regions. Each week I need to drill down on each of the regions and rename each of the new tabs with the specified region name. There are several other pivot tables on the sheet, but only one will have this process attached to it. The region names are different every week, but there will be no more than 10 at a time.
I am doing this manually at the moment, but would like to add it on to an existing automation. I'm having trouble because the amount of regions in the list changes each week.
The end product should look like this:
I have a small pivot table with data on various UK regions. Each week I need to drill down on each of the regions and rename each of the new tabs with the specified region name. There are several other pivot tables on the sheet, but only one will have this process attached to it. The region names are different every week, but there will be no more than 10 at a time.
I am doing this manually at the moment, but would like to add it on to an existing automation. I'm having trouble because the amount of regions in the list changes each week.
Sample1.xlsx | |||
---|---|---|---|
F | |||
11 | |||
Pivots |
Sample1.xlsx | |||
---|---|---|---|
B | |||
18 | YOU1591420 | ||
Data |
The end product should look like this: