|
- Sub test()
- Dim r%, i%
- Dim arr, brr
- Dim d As Object
- Set d = CreateObject("scripting.dictionary")
- With Worksheets("sheet3")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- arr = .Range("a2:m" & r)
- For i = 1 To UBound(arr)
- d(CStr(arr(i, 2))) = i
- Next
- End With
- With Worksheets("sheet1")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- brr = .Range("a2:f" & r)
- For i = 1 To UBound(brr)
- If d.exists(CStr(brr(i, 4))) Then
- m = d(CStr(brr(i, 4)))
- arr(m, 11) = brr(i, 6)
- End If
- Next
- End With
- With Worksheets("sheet3")
- .Columns(2).NumberFormatLocal = "@"
- .Range("a2").Resize(UBound(arr), UBound(arr, 2)) = arr
- End With
- End Sub
复制代码 |
评分
-
2
查看全部评分
-
|