|
本帖最后由 hwc2ycy 于 2012-9-23 16:59 编辑
- Sub s1()
- Dim arr1, arr2
- Dim dicJHY As Object, dicBJ As Object
- Application.ScreenUpdating = False
- Set dicJHY = CreateObject("scripting.dictionary")
- Set dicBJ = CreateObject("scripting.dictionary")
- Worksheets("2").Select
- arr2 = Range("a2:c" & [a2].End(xlDown).Row).Value
- Set dic = CreateObject("scripting.dictionary")
- Worksheets("1").Activate
- arr1 = Range("A2:E" & [a2].End(xlDown).Row).Value
- For i = 1 To UBound(arr2)
- dicJHY.Add arr2(i, 1), arr2(i, 2)
- dicBJ.Add arr2(i, 1), arr2(i, 3)
- Next
-
- For i = 1 To UBound(arr1)
- arr1(i, 5) = dicBJ(arr1(i, 1))
- If arr1(i, 5) <> "" Then
- arr1(i, 4) = arr1(i, 5)
- End If
- Next
- Range("a2").Resize(UBound(arr1), UBound(arr1, 2)).Value = arr1
- End Sub
复制代码 你的E列数据是不是自己算得有误啊。结果不一样嘛。 |
|