Copy, Find, replace from one excel to another excel

[Closed]
Report
-
Hi friends,

Greetings !

could you please anybody can help me to make excel macro or VBscript which should do the following steps,

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.

your help is really appreciated.

Thanks in advance for your answer!

thiagu