TheRedCardinal
Board Regular
- Joined
- Jul 11, 2019
- Messages
- 243
- Office Version
- 365
- 2021
- Platform
- Windows
I have a pivot table that has the following parameters:
Rows:
Values:
I want to copy the data only (i.e. not headings) from the following columns:
I can do this using the normal "Find column header / find last row, copy range" method but is there a better way i.e. by referencing the row headers themselves within the PivotTable object?
I tried to use the recorder to give me a clue on this one but it just selected ranges when I did it, so no help there.
Rows:
- Partner ID 1
- Partner ID 2
- Indicator
Values:
- Total Values
I want to copy the data only (i.e. not headings) from the following columns:
- Partner ID 1
- Partner ID 2
- Total Value
I can do this using the normal "Find column header / find last row, copy range" method but is there a better way i.e. by referencing the row headers themselves within the PivotTable object?
I tried to use the recorder to give me a clue on this one but it just selected ranges when I did it, so no help there.