Hi,
I have done some searching but I'm not sure how this can be done, so please forgive me if it's in the wrong section.
I have two workbooks,
'Master Records'
'Assessment Records'
The workbooks are not saved in the same location and the Master file will not necessarily be open.
When the Assessment book is opened I would like to copy certain columns from the Master sheet to Assessment. There is essentially an id field which links the records in the workbooks.
The Assessment sheet has extra information which is linked to an id, so I would like this information to be maintained.
Please see the attached files, and fire any questions back at me.
Thanks
Alex
Assessment Records.xlsx
Master Records.xlsx
Bookmarks