|
请问如何通过字典的方式让sheet(原始数据)里的内容自动统计并输出到sheet(数据输出)里,万分感谢,我目前也在学习VBA,但是是个新手,搞不定阿
- Sub XXX()
- Dim arr, Dic, brr, xrr
- arr = Sheet1.[a1].CurrentRegion
- Set Dic = CreateObject("scripting.dictionary")
- For a = 1 To UBound(arr)
- brr = Application.Index(arr, a, 0)
- If Not Dic.exists(arr(a, 1) & arr(a, 2)) Then
- Dic(arr(a, 1) & arr(a, 2)) = brr
- Else
- xrr = Dic(arr(a, 1) & arr(a, 2))
- For b = 3 To UBound(brr)
- xrr(b) = xrr(b) + brr(b)
- Next
- Dic(arr(a, 1) & arr(a, 2)) = xrr
- End If
- Next
- Sheet2.[a1].Resize(Dic.Count, UBound(xrr)) = Application.Transpose(Application.Transpose(Dic.items()))
- End Sub
复制代码
|
|