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


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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!