Link To Separate Workbook Table Help

[t0ny84]

Hi,

Can someone please tell me if the following is possible and if it is possible what would the best way be to set it up.

I am wanting to have a master Employee Spreadsheet with a table that holds all relevant data (e.g. Name, Email) that I can link to the table in a different workbook so that when changes are made in the master spreadsheet table they feed into the second workbook table.

I thought about having a macro recreate the second table each time it was opened or found a change but this caused any cells referencing the table to REF#! when run, similarly when I tried using formulas e.g. =MasterSpreadsheet!Table1[Employee Name] it would REF on changes in the primary table and also I would need to manually adjust the table.

I hope this makes sense outside of my brain!

Thanks in advance,
t0ny84

 

[t0ny84]

Though I haven't put it into practice yet I believe I have worked out the answer to my own question

Have a macro CLEAR (NOT DELETE) the table from the 2nd workbook and then rebuild it from the Employee Table in the EmployeeData workbook.
By clearing the table and not deleting it the formulas shouldn't get REF# errors.