|
- Sub Macro1()
- Dim arr, brr, crr, d, d2, i&, j%, zf$
- Set d = CreateObject("scripting.dictionary")
- Set d2 = CreateObject("scripting.dictionary")
- arr = Sheet1.Range("ae2:bu" & Sheet1.Range("bu65536").End(xlUp).Row)
- brr = [b3:ak3]
- For i = 1 To UBound(arr)
- d2(arr(i, 1)) = ""
- zf = arr(i, 1) & "," & arr(i, 2)
- d(zf) = d(zf) + arr(i, 43)
- Next
- ReDim crr(1 To d2.Count, 1 To UBound(brr, 2) + 1)
- a = d2.keys
- For i = 0 To d2.Count - 1
- crr(i + 1, 1) = a(i)
- For j = 1 To UBound(brr, 2)
- zf = a(i) & "," & brr(1, j)
- crr(i + 1, j + 1) = d(zf)
- Next
- Next
- Range("a4").Resize(UBound(crr), UBound(crr, 2)) = crr
- Range("a3").Resize(UBound(crr) + 1, UBound(crr, 2)).Sort [a4], Header:=xlGuess
- End Sub
复制代码 |
|