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

Thread: Joining Pivot Tables

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok,

    I give up....

    How do you join a pivot table??

    I have two sets of data with identical heading in different sheets of a different work book and I want to put all of this into one pivot table in a second workbook...

    is this possible??

    Cheers

    Ed

  2. #2
    Board Regular sen_edp's Avatar
    Join Date
    Mar 2002
    Location
    Hellas
    Posts
    555
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello Ed

    Yes you can do it.
    All you have to do is to consolidate the ranges you want from the pivot table wizzard.
    I tried it and it works.

    Andreas

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    cheers muchly
    Ed Jackson

    "Do not worry about your problems with mathematics, I assure you mine are far greater."

    A. Einstien

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
  •