Copy, Find, replace from one excel to another excel [Closed]

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!


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!