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
|