link tables across spreadsheets

[Ricko_uk]

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