|
- Sub 汇总()
- Dim arr, brr, i, j, r, d, n
- Set d = CreateObject("scripting.dictionary")
- With Sheet1
- r = .Cells(Rows.Count, 1).End(xlUp).Row
- arr = .Range("a2:c" & r)
- End With
- ReDim brr(1 To UBound(arr), 1 To 100)
- n = 1
- c = 1
- For i = 2 To UBound(arr)
- sa = arr(i, 1)
- sb = arr(i, 2)
- If Not d.exists(sa) Then
- n = n + 1
- d(sa) = n
- brr(1, 1) = "菜单名称"
- brr(n, 1) = arr(i, 1)
- End If
- If Not d.exists(sb) Then
- c = c + 1
- d(sb) = c
- brr(1, c) = arr(i, 2)
- End If
- x = d(sa)
- y = d(sb)
- brr(x, y) = brr(x, y) + arr(i, 3)
- Next
- Sheet1.[m2].Resize(n, c) = brr
- End Sub
复制代码 |
|