View Single Post
 
Old 02-11-2014, 08:16 AM
mtayloripf mtayloripf is offline Windows Vista Office 2010 64bit
Novice
 
Join Date: Feb 2014
Posts: 1
mtayloripf is on a distinguished road
Default Consolidate Pivots linked to SQL

Hi All,

Hope you can help, here is my problem:
- I have 3 separate pieces of SQL code. Each one is pulling the same type of sales data from different servers (each server is from a different country).
- I then have 3 excel workbooks (one for each country) which contain many pivot tables which are linked to their relevant SQL codes.
- Each week I run the code and refresh the excel pivots to get the latest sales figures.
- There is now the need to integrate all 3 excel workbooks, so sales figures of the 3 countries can be viewed side by side e.g. in the same table or on the same graph.
- Is there a way of integrating pivot tables from different workbooks into one table?
- I am really trying to avoid having to either combine the SQL codes (very complicated) or copy and paste all the pivots into one workbook (really time consuming/lots of pivots)

Note my VBA skills are very limited

Does anyone have any ideas?
Thanks in advance

Reply With Quote