|
|
#1
02-11-2014, 08:16 AM
|
|||
|
|||
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 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Consolidate names
|
jgross30 | Excel | 7 | 05-13-2013 08:36 PM |
|
Doing a linked paste within a linked spreadsheet
|
tkondaks | Word | 1 | 08-17-2012 12:23 AM |
| Consolidate - does not work in 2007 version | Jirik61 | Excel Programming | 10 | 08-08-2012 04:59 AM |
| Linked graphics | eNGiNe | Word | 2 | 02-20-2012 10:52 PM |
| Linked Tables | afpapa2 | PowerPoint | 0 | 12-01-2011 09:25 AM |
Windows Vista 
Office 2010 64bit
Linear Mode
