|
Sub lqt()
Set wb = GetObject(ThisWorkbook.Path & "\" & "表1.xls")
Set d = CreateObject("scripting.dictionary")
With Workbooks("表1.xls")
arr = .Sheets(1).UsedRange
For i = 2 To UBound(arr)
d(arr(i, 4)) = Array(arr(i, 2), arr(i, 5), arr(i, 13), arr(i, 14), arr(i, 11))
Next
End With
arr = [a2].CurrentRegion
For i = 2 To UBound(arr)
If d.exists(arr(i, 1)) Then
s = d(arr(i, 1))
For j = 0 To UBound(s)
arr(i, j + 2) = s(j)
Next
End If
Next
[a2].Resize(UBound(arr), 6) = arr
Set wb = Nothing
Set d = Nothing
End Sub |
评分
-
1
查看全部评分
-
|