I need assistance with writing a macro to update data from one workbook to another?

[ANTON_NORTJE]

I need to find a value (client name) in a column and replace it with a corresponding value (client name) in another workbook.


In other words, if the value (client name) in the first column in workbook 1 is "X",
I need it to look in workbook 2 for "X" and return/update what is in column 2 TO 5 in workbook 1 in the same row in workbook 2?