|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub test()
- Dim r%, i%
- Dim arr, brr
- Dim d As Object
- Set d = CreateObject("scripting.dictionary")
- With Worksheets("sheet1")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- arr = .Range("a2:d" & r)
- For i = 1 To UBound(arr)
- If Not d.exists(arr(i, 2)) Then
- Set d(arr(i, 2)) = CreateObject("scripting.dictionary")
- End If
- d(arr(i, 2))(arr(i, 3)) = d(arr(i, 2))(arr(i, 3)) + arr(i, 4)
- Next
- m = 2
- For Each aa In d.keys
- .Cells(m, 16) = aa
- ss = ""
- For Each bb In d(aa).keys
- ss = ss & "+" & d(aa)(bb) & bb
- Next
- .Cells(m, 17) = Mid(ss, 2)
- m = m + 1
- Next
- End With
- End Sub
复制代码 |
|