happydonut
Board Regular
- Joined
- Nov 28, 2019
- Messages
- 57
- Office Version
- 365
- Platform
- Windows
Hi,
I have a request and was hoping someone could help.
I have a Macro that turns data in Excel to a Pivot table.
When that is done, I can double click on a value in the Pivot Table, and a more detailed view shows. At the same time, a new Sheet gets created and gets opened. Is it possible to rename this new Sheet automatically? Preferably to the value on the same row, see example:
(When double clicking the amount, it will open a new Sheet, which should named Salary).
I have a request and was hoping someone could help.
I have a Macro that turns data in Excel to a Pivot table.
When that is done, I can double click on a value in the Pivot Table, and a more detailed view shows. At the same time, a new Sheet gets created and gets opened. Is it possible to rename this new Sheet automatically? Preferably to the value on the same row, see example:
Column A | Column B | |
Row 1 | Salary | 100 000 |
(When double clicking the amount, it will open a new Sheet, which should named Salary).