I have data in a pivot table that I want to copy into another worksheet. Is there a formula I can use to do this, and that will also update data in the second worksheet if the data in the pivot table changes? Basically, I don't want to have to copy paste all the time.
The columns in the section of the second worksheet where I want to copy the pivot table data has the same headers as the pivot table.
Contract Number Bus. Unit T5 Code Client Name Currency Code
10001379 QJ-01-A C102102 JP MORGAN USD
10009921 QJ-01-A C104613 UBS USD
10009924 QJ-01-A C104767 UBS USD
The columns in the section of the second worksheet where I want to copy the pivot table data has the same headers as the pivot table.
Contract Number Bus. Unit T5 Code Client Name Currency Code
10001379 QJ-01-A C102102 JP MORGAN USD
10009921 QJ-01-A C104613 UBS USD
10009924 QJ-01-A C104767 UBS USD