Sub TEST()
Dim B(1 To 1, 1 To 13)
Set D = CreateObject("Scripting.Dictionary")
For I = 2 To Sheets.Count
ARR = Sheets(I).UsedRange
For J = 2 To UBound(ARR)
S = ARR(J, 1) & "+" & ARR(J, 2) & "+" & ARR(J, 3) & "+" & ARR(J, 4)
If Not D.EXISTS(S) And ARR(J, 1) <> "" Then
SS = 0
For K = 1 To 12
B(1, K + 1) = ARR(J, K + 4)
SS = SS + ARR(J, K + 4)
Next
B(1, 1) = SS
D(S) = B
End If
Next
Next
With Sheets("汇总")
For Each D1 In D.KEYS
N = N + 1
.Cells(N + 1, 1).Resize(1, 4) = Split(D1, "+")
.Cells(N + 1, 5).Resize(1, 13) = D(D1)
Next
End With
End Sub
|