• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 20. Using PivotTables and PivotC... > Creating a PivotTable from Multiple ...

Creating a PivotTable from Multiple Ranges

Excel enables you to create PivotTables from multiple consolidation ranges by selecting the multiple consolidation control from Step 1 of the PivotTable Wizard. For example, if you have two companies with product sales or two divisions with product sales, you can establish separate worksheets or databases to control the list and then combine into a multiple consolidated PivotTable. (The wizard walks you through step by step.) Figure 20.48 shows Step 2b of 3 of the PivotTable Wizard, which enables you to browse through documents to find the lists or ranges. Drag over the range of data you want to consolidate and click the Add button to add it to the All Ranges section of the dialog box. If your consolidation ranges are coming from multiple files (as opposed to sheets), you can use the Browse button to select unopened files. The problem is that the Browse button doesn't actually open the files. Unless you've memorized the data ranges (addresses or range names), it's better to open the files before starting the PivotTable Wizard. The only time this could be a problem is if you have numerous files to open and restricted computer memory. In such a case, name each consolidation range so that you can manually type it in the Range box.

Figure 20.48. To consolidate lists into a PivotTable, select the consolidation ranges in Step 1 of the PivotTable Wizard and add the ranges together.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint