|
POWER(1-12月)的工作表C20到C30的机种与D19到O12的月份联合起来,求axmr731工作表的对应项加总,最后输入到[size=13.9999990463257px]POWER(1-12月)的工作表D20到C30,求VBA代码,最好用字典,万分感谢
详见附件
- Sub 汇总()
- Dim arr, i&, j&, d, x
- arr = Sheets("axmr731").[a1].CurrentRegion
- Set d = CreateObject("scripting.dictionary")
- For i = 2 To UBound(arr)
- For j = 5 To 16
- x = arr(i, 1) & arr(1, j)
- d(x) = d(x) + arr(i, j)
- Next
- Next
- arr = Sheets("POWER(1-12月)").[a19].Resize(11, 15)
- For i = 2 To UBound(arr)
- For j = 4 To 15
- x = arr(i, 3) & arr(1, j)
- If d.exists(x) Then
- arr(i, j) = d(x)
- End If
- Next
- Next
- [d20:o30].ClearContents
- [a19].Resize(11, 15) = arr
- Erase arr
- Set d = Nothing
- End Sub
复制代码
|
|