代码放 sheet2
- Dim vntD, I, T, K, vntR
- Dim objD As Object
- Set objD = CreateObject("Scripting.Dictionary")
- vntD = Sheets("sheet1").UsedRange
- For I = 2 To UBound(vntD)
- T = vntD(I, 1) & "/" & vntD(I, 2)
- objD(T) = objD(T) + vntD(I, 3)
- Next
- ReDim vntR(objD.Count - 1, 1)
- For I = 0 To objD.Count - 1
- vntR(I, 0) = Split(objD.keys()(I), "/")(0)
- vntR(I, 1) = Split(objD.keys()(I), "/")(1)
- Next
- Range("A1:C1") = Sheets("sheet1").Range("A1:C1").Value
- Range("A2").Resize(I, 2) = vntR
- Range("C2").Resize(I) = Application.WorksheetFunction.Transpose(objD.items())
- Range("A1:C1").Resize(I + 1, 3).Sort Range("A1"), xlAscending, Range("B1"), Header:=xlYes
- End Sub
复制代码 |