|
- Sub test()
- Dim i&, j&, k&, arr, brr
- Set dic = CreateObject("scripting.dictionary")
- arr = Sheets(2).[a1].CurrentRegion
- brr = Sheets(1).[a1].CurrentRegion
- For i = 1 To UBound(arr)
- dic(arr(i, 1)) = Array(arr(i, 2), arr(i, 3))
- Next
- For j = 1 To UBound(brr)
- If dic.exists(brr(j, 1)) Then
- brr(j, 2) = dic(brr(j, 1))(0)
- brr(j, 3) = dic(brr(j, 1))(1)
- End If
- Next
- Sheets(1).[a1].Resize(UBound(brr), 3) = brr
- End Sub
复制代码 |
评分
-
查看全部评分
|