Pivot Tables

  • Thread starter Thread starter TBird
  • Start date Start date
T

TBird

I developed a pivot table using multiple consolidation
ranges from three seperate sheets in the same workbook.
Now I want to add more sheets. How do I do this without
re-creating the whole pivot table?
 
Select a cell in the Pivot Table
From the PivotTable toolbar, choose PivotTable>Wizard
Click the Back button
Select the range you want to add
Click the Add button, click Finish
 
Back
Top