Excel: Push data to closed Workbook

@ouestque Hi there! :)

First of all, I assume you have refered to the article below?

Reference: https://www.encodedna.com/excel/copy-data-from-closed-excel-workbook-without-opening.htm

Then again, is it really necessary to go through all the extra pain of creating a Subroutine to link cells when you can this:

Instead of Sheet1A1, you will just need to click on the reference cell you want to call in the other workbook.

Please try to use Power Query to merge your data, no need VBA code.
After setting it up, you can just click refresh to update the data.

If you need VBA code, you design your code :
1.Open workbook2 in background, and assign your data to one array; then close it.
2.Comparing the data btw workbook1 & workbook2 to find the different with key field,
3.If Key1 with new value in workbook2,  and update Key1 in workbook1

Please upload sample workbook1/2, so we can write the code for you.

as suggested by Benjamin Lu, I would use Power Query AKA Get and Transform instead of any other solution.

Thank you everyone!