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

[ANTON_NORTJE]

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:
REF	CLIENT	CURR	30	60	90	120	120+	REMARKS
ref1	AA	100>>						abc
ref2	BB		200					rrr
ref3	CC				300			qqq
ref4	DD						600	ttt

<colgroup><col width="64" style="width: 48pt;" span="9"> <tbody> </tbody>

WORKBOOK 2:
REF	CLIENT	CURR	30	60	90	120	120+	REMARKS	TOTAL	PMT DATE
ref1	AA	100>>						abc
ref2	BB		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>