Copy Pivot and Charts, Modify Source (VBA)

In Excel 2007, it is not directly possible to change the data source for a pivot chart, but this code that shows how to copy a worksheet while repointing the pivot charts to the copied pivot table, rather than the having them reference the source pivot table.

Click the download button for VBA_CopyAndRepoint.txt... Download Code