Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Pivot multiple ranges?

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is it possible to pivot multiple ranges on several tabs in the same workbook?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes, that's what the "Multiple consolidation ranges" option at Step 1 of 4 in the PivotTable wizard is for. However, you need to understand that this feature is intended for the consolidation of 1 or 2-dimensional data tables with common row and/or column labels. The Consolidation feature existed long before PivotTables. I'd recommend that you "bone up" on the concept by consulting the following Excel Help Index topics...

    1. Consolidate data

    2. Guidelines for specifying source areas for a consolidation

    3. About creating a PivotTable to consolidate multiple data ranges

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •