|
发表于 2017-3-20 13:47
|
显示全部楼层
本楼为最佳答案
- Sub tt()
- Set d = CreateObject("scripting.dictionary")
- arr = Sheet1.Range("a5:f" & Sheet1.[a65536].End(3).Row)
- For i = 1 To UBound(arr)
- x = Day(CDate(arr(i, 1))) + 1 & arr(i, 4) & arr(i, 5) '日、图号、生产班次为key(没搞清为什么要day+1结果才正确)
- d(x) = d(x) + arr(i, 6)
- Next
- With Sheet2
- arr = .[a1].CurrentRegion
- For j = 2 To UBound(arr, 2)
- If arr(1, j) = "" Then arr(1, j) = arr(1, j - 1)
- For i = 3 To UBound(arr)
- x = arr(1, j) & arr(i, 1) & arr(2, j) '日、图号、生产班次为key
- arr(i, j) = d(x)
- Next
- Next
- .[a1].CurrentRegion = arr
- End With
- End Sub
复制代码 |
|