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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks