|
Sub test()
Dim A, B, d, i
A = Sheets(1).[A4:M17]
B = Sheets(2).[A16:F25]
Set d = CreateObject("scripting.dictionary")
For i = 1 To UBound(A)
d(A(i, 2)) = d(A(i, 2)) & ";" & A(i, 13) & A(i, 12)
Next i
For i = 1 To UBound(B)
B(i, 6) = Mid(d(B(i, 1)), 2)
Next i
Sheets(2).Range("a16").Resize(UBound(B, 2), UBound(B, 2)) = B
End Sub
3.rar
(24.57 KB, 下载次数: 10)
|
|