|
Sub mydemo()
Dim r&, ar, s$, i&, d As Object
r = Sheet2.Cells(Rows.Count, "a").End(xlUp).Row
If r > 1 Then
ar = Sheet2.[a1].Resize(r, 4)
Set d = CreateObject("Scripting.Dictionary")
For i = 2 To UBound(ar)
s = ar(i, 1) & "☆" & ar(i, 2) & "☆" & ar(i, 3)
If ar(i, 4) <> "" Then
d(s) = ar(i, 4)
End If
Next
r = Sheet1.Cells(Rows.Count, "a").End(xlUp).Row
If r > 1 Then
ar = Sheet1.[a1].Resize(r, 4)
For i = 2 To UBound(ar)
s = ar(i, 1) & "☆" & ar(i, 2) & "☆" & ar(i, 3)
If d.exists(s) Then
ar(i, 4) = d(s)
End If
Next
Sheet1.[a1].Resize(r, 4) = ar
End If
Set d = Nothing
Else
Exit Sub
End If
End Sub |
|