Browse » Home
Sunday, December 25, 2011
How to Create a Pivot Table From Multiple Pivot Tables
1. Open the PivotTable you would like to work with. Also open a worksheet you would like to consolidate all other pivot table information onto from one PivotTable.
2. Click on a cell with the new worksheet where you want to start the consolidated data.
3. Click 'Consolidate' on the Data menu.
4. Click on 'Sum' (or another function) in the Summary function in the Function box. This is the function you want Microsoft Excel to use to consolidate the data.
5. Input the sheet tab of the first range to consolidate in the Reference box and repeat for each PivotTable you want to grab information from. Select 'Create links to source data' check box if you want to update the data and need to know which PivotTables are open to access the data.
6. Create a new PivotTable from the consolidated data. On the Data menu, click 'PivotTable and PivotChart Report.' Use the data from the consolidated worksheet for your data range and click through all other options. Click 'Finished' for consolidated PivotTable.