Consulting | Excel Examples

Creating an Automatic Copy of a Pivot Table

Keywords: Pivot Table, Copy, VBA

Description: Simple VBA macro to change PivotTable and create copy on another worksheet.

Tip: You can copy a PivotTable to another worksheet and manipulate the copy in ways not permitted in the PivotTable. With a few lines of VBA code, you can automatically update the PivotTable and update the copy. The PivotTable copy can be used to create special subtotals or formatting not allowed in the PivotTable.

Guide to the Example: The Update Pivot button on the Pivot Copy worksheet displays the Pivot Table wizard, allows changes in the origianl PivotTable and automatically re-copies the PivotTable to the PivotCopy worksheet.

Download File: Click Here
Tip: Click on the link above and choose "Save" to download the xls workbook to your hard drive or "Open" to open the workbook inside of your browser.


Last modified: May 21, 1996