|
本帖最后由 ruhong18 于 2019-12-26 14:59 编辑
Sub 宏1()
Dim arr, brr(1 To 100000, 1 To 8), i&, j&, m&, t, d As Object, sh As Worksheet
Set d = CreateObject("scripting.dictionary")
For Each sh In Worksheets
If sh.Name <> "汇总" Then
arr = sh.[a1].CurrentRegion
For i = 3 To UBound(arr)
t = d(arr(i, 3))
If t = "" Then
m = m + 1
d(arr(i, 3)) = m
For j = 3 To 8
brr(m, j) = arr(i, j)
Next
Else
For j = 4 To 8
brr(t, j) = brr(t, j) + arr(i, j)
Next
End If
Next
End If
Next
ActiveSheet.UsedRange.Offset(2).ClearContents
Range("c3").Resize(m, 8) = brr
End Sub
另外,如何再该代码的汇总页,内容尾行添加合计?(增加语句)
|
|