Sub test()
Dim A, d, i, j, k
Set d = CreateObject("scripting.dictionary")
'1)写入字典
Sheets(1).Select
i = Range("a65536").End(xlUp).Row
A = Range("a1:e" & i)
For i = 3 To UBound(A)
For j = 3 To UBound(A, 2)
k = A(i, 1) & "," & A(i, 2) & "," & A(2, j)
d(k) = A(i, j)
Next j
Next i
'2)读取字典
Sheets(2).Select
i = Range("a65536").End(xlUp).Row
A = Range("a1:c" & i)
For i = 4 To UBound(A)
k = A(i, 1) & "," & A(i, 2) & "," & A(2, 3)
A(i, 3) = d(k)
Next i
[c4:c65536] = ""
Range("A1").Resize(UBound(A), UBound(A, 2)) = A
End Sub
1.rar
(17.71 KB, 下载次数: 5)
|