Sub AwTest()
Dim i&, j%, r&, s1, s2, arr
arr = Range("A1:D" & Cells(Rows.Count, 2).End(3).Row + 1)
ReDim brr(1 To UBound(arr) * 2, 1 To UBound(arr, 2))
For i = 2 To UBound(arr) - 1
s1 = s1 + arr(i, 3): s2 = s2 + arr(i, 4)
r = r + 1
For j = 1 To UBound(arr, 2)
brr(r, j) = arr(i, j)
Next
If Len(arr(i + 1, 1)) Then r = r + 1: brr(r, 2) = "合计": brr(r, 3) = s1: brr(r, 4) = s2: s1 = 0: s2 = 0
Next
If s1 <> 0 Or s2 <> 0 Then r = r + 1: brr(r, 2) = "合计": brr(r, 3) = s1: brr(r, 4) = s2
[a1].CurrentRegion.Offset(1) = ""
[a2].Resize(r, 4) = brr
End Sub |