tommasotolu
New Member
- Joined
- Jul 5, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I anticipate that maybe this is a very simple task for the majority of you, at least I hope.
I need to automate the creation of Pivot tables. The Pivots will need to be within the same worksheet, but each Pivot refers to a single sheet. Every sheet contains raw data structured as a table (the structure of the table is constant, except for the fact they may vary in terms of rows).
Can you give me some directions on how to move? Unfortunately, I cannot share the file since it contains private company data.
Moreover, the VBA will need to be shared with other colleagues. Which is the fastest and easier way to share it and implement it? (Considering that some colleagues may be even less skilled at Excel Programming than me).
Thanks,
Tommaso.
I need to automate the creation of Pivot tables. The Pivots will need to be within the same worksheet, but each Pivot refers to a single sheet. Every sheet contains raw data structured as a table (the structure of the table is constant, except for the fact they may vary in terms of rows).
Can you give me some directions on how to move? Unfortunately, I cannot share the file since it contains private company data.
Moreover, the VBA will need to be shared with other colleagues. Which is the fastest and easier way to share it and implement it? (Considering that some colleagues may be even less skilled at Excel Programming than me).
Thanks,
Tommaso.