#1
|
|||
|
|||
link tables across spreadsheets
Hi,
I have Spreadsheet A and Spreadsheet B. They are 2 separate files always in the same file location and always inside the same folder. Spreadsheet A is always called "Spreadsheet_A" and Spreadsheet B is always called "Spreadsheet_B". I want to implement the following but haven't yet found a way: 1) have a table in Spreadsheet A named "Table_1" to appear in Spreadsheet B when I open it 2) it must be automatic so no copy paste, no import or any other operation like that. Just some kind of dynamic link of some sort?? So whenever I open Spreadsheet B whatever is in Table_1 appears there without me doing anything. 3) if I change the data in the original table ("Table_1" on Spreadsheet A") the data is automatically updated in Spreadsheet B. That includes if the number of rows in Table_1 increases or decreases (columns are always the same and with the same name). Anybody can help? Thank you |
#2
|
|||
|
|||
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Link parts of excel spreadsheets in powerpoint and change source of links | ahet | PowerPoint | 0 | 10-05-2016 01:37 AM |
Link Tables in multiple documents | Stormie | Word Tables | 4 | 05-24-2016 06:53 PM |
Merging Two Spreadsheets | buechler66 | Excel Programming | 1 | 03-25-2015 11:57 AM |
Can't open spreadsheets | kaygeea | Excel | 7 | 10-05-2011 08:00 AM |
Merging two spreadsheets | BrazzellMarketing | Excel | 5 | 04-26-2011 01:51 PM |