Copy, find, replace from one excel to another excel

[Closed]
Report
-
Hello,

i like to make marcro which should do the following step,

1.copy the cells from A2 to D100 in Excel A and it has to search the copied values in Excel B.

2.If the copied values are matching in the Excel B, then the matched values row in the Excel A should replace the matched rows in excel B.