Simple Multiple Source Pivot
Follow these steps to create a pivot table from multiple sources (same of other file). See attached example file.
Steps :
1a In Excel 2003 open the PivotTable and PivotChart wizard by choosing Data -> PivotTable and PivotChart Report.
1b In Excel 2007, press Alt+DP, then type P to open the wizard as there is no equivalent menu option.
2 Choose Multiple Consolidation ranges
3 Open file B as well
4 Choose relevant page field option
5 Simply select and add the ranges (highlighted cells) from this and other file. You can choose to have as many files (A+B)
6 Select New Sheet & Finish
Attachment | Size |
---|---|
MultipleSourcePivot.xls | 25.5 KB |
- Vishesh's blog
- Login or register to post comments
- 4984 reads
Recent comments
5 years 47 weeks ago
6 years 33 weeks ago
6 years 45 weeks ago
6 years 48 weeks ago
6 years 49 weeks ago
7 years 2 weeks ago
7 years 10 weeks ago
7 years 11 weeks ago
7 years 11 weeks ago
7 years 11 weeks ago