|
Sub 汇总()
Application.ScreenUpdating = False
Dim ar As Variant
Dim d As Object
Dim br()
Set d = CreateObject("scripting.dictionary")
ReDim br(1 To 50000, 1 To 3)
For Each sh In Sheets
If sh.Name <> "总表" Then
r = sh.Cells(Rows.Count, 1).End(xlUp).Row
If r > 1 Then
ar = sh.Range("a1:c" & r)
For i = 2 To UBound(ar)
If ar(i, 1) <> "" Then
t = d(ar(i, 1))
If t = "" Then
k = k + 1
d(ar(i, 1)) = k
t = k
br(k, 1) = ar(i, 1)
End If
For j = 2 To UBound(ar, 2)
br(t, j) = br(t, j) + ar(i, j)
Next j
End If
Next i
End If
End If
Next sh
With Sheets("总表")
.[a1].CurrentRegion.Offset(1).Borders.LineStyle = 0
.[a1].CurrentRegion.Offset(1) = Empty
.[a2].Resize(k, UBound(br, 2)) = br
.[a2].Resize(k, UBound(br, 2)).Borders.LineStyle = 1
End With
Application.ScreenUpdating = True
MsgBox "ok!"
End Sub
|
|