Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2

I have been searching for this for whole day and since my vba knowledge is not that great, I am unable to make this thing happen. What I am looking to do is I have a sheet 1 with 4000 records, and sheet 2 contains regular updates that we do.

I am looking to find cell vaule of Column A value of Sheet 2 in Column M of Sheet 1 and if it is found then replace Column B and C for the respective row in Column M.

For e.g. In the sample sheet below, Shipment No and Shipment Date needs to be updated in Sheet 1, for the specific no. of items that are now updated in sheet 2. The unique column between two sheets is Document which is Column M in Sheet 1 and Column A in Sheet 2.

On a regular basis there are 3800-4000 permanent items in sheet 1, sheet 2 just contains shipment updates which are 30-50 daily.

Any help in this regard is highly appreciated.

Originally Posted by Mumps1

Try:

Please Login or Register  to view this content.

Thanks a ton, this works smoothly, you saved me!

Is it possible, to modify the macro to add a condition that if the shipment no is same as new one, don't change the date.

This works wonderfully! Thank you very much!

Originally Posted by Mumps1

Try:

Please Login or Register  to view this content.

Thank you very much for this!

Originally Posted by sintek

Just for the fun of other options...

Please Login or Register  to view this content.