View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default 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