Macro to find/loop matchings names in 2 workbooks, update/add values

ANTON_NORTJE

New Member
Joined
Aug 28, 2014
Messages
3
Greetings everybody,

I will really appreciate if some-one could assist me with the following challenge as I have been searching for a solutions endless.



SCENARIO (accounting concept):


[1] I have 2 workbooks with columns as example.

[2] Macro to find matching "client" in the 2 WB'S, if the values/remarks are changed in WB1, it must

updated in WB2. (i.e. If in WB1 "client-AA", 100 moves from CURR to 60 or any of the next

columns, it must be updated in WB2)

[3] In the same instance, if new clients are added in WB1, the whole row must be updated in WB2.

(i.e. If in WB1 a new "client" is added, then the whole row is updated in WB2)



I trust this makes sense.


Regards



Anton


WORKBOOK 1:
REFCLIENTCURR306090120120+REMARKS
ref1AA100>> abc
ref2BB 200 rrr
ref3CC 300 qqq
ref4DD 600ttt
<colgroup><col width="64" style="width: 48pt;" span="9"> <tbody> </tbody>
WORKBOOK 2:
REFCLIENTCURR306090120120+REMARKS TOTAL PMT DATE
ref1AA100>> abc
ref2BB 200 rrr
>>>>>> >>> >>>
>>>>>> >>>>>>
<colgroup><col width="64" style="width: 48pt;" span="10"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"> <tbody> </tbody>



 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,108,817
Messages
5,525,068
Members
409,617
Latest member
Lenaf

This Week's Hot Topics

Top