|
本帖最后由 诺然偶然 于 2017-3-10 16:34 编辑
需要将工作表数据与数据表的匹配,也是大神给写的代码,看了好久,依葫芦画瓢修改了下,但是后面的比列没有匹配上,求指导,或者有更好的方法请不吝赐教,先谢过了!!!
- Sub test()
- Application.ScreenUpdating = False
- Dim d, arr, brr, crr, r&
-
- Set d = CreateObject("scripting.dictionary")
- arr = ThisWorkbook.Sheets(2).[a1].CurrentRegion
- For r = 2 To UBound(arr)
- d(arr(r, 1)) = arr(r, 3)
- Next
- crr = ThisWorkbook.Sheets(4).[a1].CurrentRegion
- For r = 2 To UBound(crr)
- d(crr(r, 1)) = crr(r, 2)
- Next
-
- With Workbooks(2).Sheets(1) '这里最好写workbooks(文件名)
- brr = .[a1].CurrentRegion
- For r = 2 To UBound(brr)
- brr(r, 3) = d(brr(r, 2))
- brr(r, 5) = d(brr(r, 4))
- Next
- .[a1].Resize(UBound(brr), UBound(brr, 2)) = brr
- End With
- Set d = Nothing
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|