|
发表于 2016-1-31 16:53
|
显示全部楼层
本楼为最佳答案
thelastdance 发表于 2016-1-31 16:42
在B2:B45输入结果,C2:C45是B列的模拟结果
引用数据源在表名“开票”
重新写一下,这样对吗?- Sub test()
- Dim d As Object, arr, i&, j&
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets("开票").Range("a1").CurrentRegion
- For i = 2 To UBound(arr)
- d(arr(i, 4)) = d(arr(i, 4)) + arr(i, 3)
- Next
- With Sheet1
- .[b2:b1000] = ""
- arr = .Range("a1").CurrentRegion
- For i = 1 To UBound(arr)
- If d.exists(arr(i, 1)) Then arr(i, 2) = d(arr(i, 1))
- Next
- .[a1].Resize(i - 1, 3) = arr
- End With
- MsgBox "处理完毕!"
- End Sub
复制代码
查找数据求助20160131(可用VBA).rar
(19.53 KB, 下载次数: 4)
|
|