+ Reply to Thread
Results 1 to 2 of 2

Can you join multiple databases using a pivot table?

  1. #1
    lbraunbe
    Guest

    Can you join multiple databases using a pivot table?

    I have recently been trying to learn and use pivot tables. Is there a way to
    connect 2 or more databases in a pivot table? In other words pull selected
    data out of 2 databases using a pivot table.

  2. #2
    Debra Dalgleish
    Guest

    Re: Can you join multiple databases using a pivot table?

    You can create a pivot table from data on separate sheets (multiple
    consolidation ranges), but the results may not be exactly what you want.
    There's more information here:

    http://www.contextures.com/xlPivot08.html

    lbraunbe wrote:
    > I have recently been trying to learn and use pivot tables. Is there a way to
    > connect 2 or more databases in a pivot table? In other words pull selected
    > data out of 2 databases using a pivot table.


    --
    Debra Dalgleish
    Contextures
    http://www.contextures.com/tiptech.html


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1