Consolidate Pivot table from multiple files
Pivot Table Multiple Consolidation Ranges
Select: I will create the page fields
In Step 2b, enter and add the ranges from the 3 sheets.
Click "1" at: How many page fields do you want?
In All Ranges: Click on the first range. It may say
China!A1:K50
Type into Field One: "China"
Click on the second range. It may say
UK!A1:L50
Type into Field One: "UK" or "England"
Repeat for the rest of the ranges in All Ranges.
Layout: Drag Page1 to PAGE
Finish.
In the upper left corner of your PT,
you will have a Page1 field from which you can select
"China", "UK", "All", etc
|