|
- Sub test()
- Dim d As Object
- Dim r%, i%
- Dim arr, brr
- Set d = CreateObject("scripting.dictionary")
- With Worksheets("sheet2")
- r = .Cells(.Rows.Count, 2).End(xlUp).Row
- arr = .Range("b3:f" & r)
- For i = 1 To UBound(arr)
- d(arr(i, 1)) = i
- Next
- End With
- With Worksheets("sheet1")
- r = .Cells(.Rows.Count, 2).End(xlUp).Row
- brr = .Range("b4:t" & r)
- For i = 1 To UBound(brr)
- If d.Exists(brr(i, 1)) Then
- n = d(brr(i, 1))
- brr(i, 10) = arr(n, 3)
- brr(i, 11) = arr(n, 4)
- brr(i, 14) = arr(n, 5)
- End If
- Next
- .Range("b4").Resize(UBound(brr), UBound(brr, 2)) = brr
- End With
-
-
- End Sub
复制代码 |
|