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.