|
本帖最后由 东来之峰 于 2015-5-21 17:27 编辑
功能要求:使用VBA实现产品种类分类汇总对应的金额,请教大家怎么实现,先谢谢了
- Sub demo()
- Dim dic As Object, i%, arr
- Set dic = CreateObject("Scripting.Dictionary")
- With ThisWorkbook.Sheets("数据库")
- arr = .Range("A4:B" & .Cells(Rows.Count, 1).End(xlUp).Row)
- For i = LBound(arr) To UBound(arr)
- dic(arr(i, 1)) = dic(arr(i, 1)) + arr(i, 2)
- Next
- Sheets("汇总表").Range("B4").Resize(dic.Count, 2) = Application.Transpose(Array(dic.keys, dic.items))
- End With
- Set dic = Nothing
- End Sub
复制代码
|
|