Change the workbook names (in red) and sheet names (in blue) to suit your needs.
Sub CompareData()
Application.ScreenUpdating = False
Dim srcWS As Worksheet, desWS As Worksheet, v1 As Variant, v2 As Variant, dic As Object, i As Long
Set desWS = Workbooks("wb1.xlsx").Sheets("Sheet1")
Set srcWS = Workbooks("wb2.xlsx").Sheets("Sheet1")
v1 = srcWS.Range("A2", srcWS.Range("A" & Rows.Count).End(xlUp)).Resize(, 13).Value
v2 = desWS.Range("A2", desWS.Range("A" & Rows.Count).End(xlUp)).Value
Set dic = CreateObject("Scripting.Dictionary")
For i = LBound(v1) To UBound(v1)
If Not dic.exists(v1(i, 1)) Then
dic.Add v1(i, 1), v1(i, 13)
End If
Next i
For i = LBound(v2) To UBound(v2)
If dic.exists(v2(i, 1)) Then
desWS.Range("M" & i + 1) = dic(v2(i, 1))
End If
Next i
Application.ScreenUpdating = True
End Sub
Bookmarks