Changing the data of a Pivot Table

B

Bonbon

Hi, im just wondering is there any way of changing the data in a Pivot table?
Because i want to copy the pivot table to a different sheet, but use
different data.

Any help would be hugely appreciated
bonbon
 
R

Roger Govier

Hi
Having copied your PT to another sheet, right click in the PT to bring
up the PT toolbar.
Select the Pivot Table dropdown, then the PT wizard.
Click back twice and change the data source to your new data source.
 
B

Bonbon

Cool, thanks Roger, that helped =)
There another problem though, when i copy the new data source for the PT (as
a Macro record) it continues to select this range, but for the new PTs i need
the Newer data source. Do you know what is the code i need to solve this?

Thx in advance,
Bonbon
 
Top