Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combine Data for Pivot Table (2003 sp2)

    Hi All,

    I have a workbook with 2 tabs one is a continuation of the first. (too many lines....)

    Is is possible to get all of the data from BOTH tabs into one pivot Table?

    Thanks,
    Brad

  2. #2
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine Data for Pivot Table (2003 sp2)

    There is a website,http://www.datapigtechnologies.com/, that has a Pivot table tutorial on how to do multiple pt sources. That might have your answer. A little 5 minute show. HTH

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine Data for Pivot Table (2003 sp2)

    Guess Im not seeing the vid.

    Maybe it is the $ 25 one....


    Any other ideas?


    Thanks,
    Brad

  4. #4
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine Data for Pivot Table (2003 sp2)

    Got it!

    Select Pivot table Wizard, then Multiple consolidations. select the first, add to the list, then select the next range and complete the dialog boxes.


    Brad

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combine Data for Pivot Table (2003 sp2)

    Put your data in an Access database. You can create a pivot table in Excel based on data in Access.

Posting Permissions

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