Updating Value of a cell through Cell Address from different workbook

[Amit Punia]

2 files are attached in this thread. In the "Originating File.xlsm", Column B tells the Sheet name and Column C consists the cell address. There is Column A which is having all the amounts.
Need a VBA code which checks data in Column B and C and update the amount from Column A to the cell address mentioned in Column C.

For e.g. The first one is referring to cell F10 in cell C2. So if the value of cell B2 is "Profit & Loss Account", the code should go directly in workbook "Target File.xlsx" and activate "Profit & Loss Account" sheet, after that if the value of cell C2 is "F10" then the code should go to in cell F10 of of the same sheet(i.e. "Profit & Loss Account") and it should update the value of Amount from Cell A2("Originating File").

So in "Target File.xlsx", Cell F10 should have "55" number inside the cell.

In Target File, all the cells which are going to be affected are in Yellow Color.

 

[Amit Punia]

Ignore "Originating File.xlsm with file size 9.2 KB.

Kindly consider Originating File.xlsm with file size 9.5 KB.

 

[vletm]

Amit Punia
Like this ...
1) open 'Target File.xlsx'
2) open 'Originating File.xlsm'
3) press [ Do It ]

 

[Amit Punia]

@vletm The "Do It" is working absolutely fine. However I'm not able to see any codes in the background. This was just the demo file. Have to work on the main file using the code. So need to modify the codes accordingly. Could you please share the VBA code here.

Thank you so much for sharing the solution

 

[Amit Punia]

Got the codes, it was in the "workbook". Had to change it using drop down menu from "(General)" to "Workbook"

 

[vletm]

Amit Punia
All code is there ...
without code that couldn't work,
just take sunglasses away ..
... modify it as needs ..

 

[Amit Punia]

Yes, Got the codes.
Thank you very much @vletm