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