| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Pivot Table to consolidate multiple worksheets | Excel Discussion (Misc queries) | |||
| How do I consolidate multiple worksheet files into one workbook | Excel Discussion (Misc queries) | |||
| How can I consolidate files in Excel? | Excel Discussion (Misc queries) | |||
| how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
| Consolidate data from several worksheets via pivot table | Excel Worksheet Functions | |||
Threaded Mode
