- Sub hz()
- Dim sh As Worksheet, r As Long, S1 As Worksheet, arr, brr()
- Set S1 = Sheets("汇总")
- S1.Range("A6:f65536").ClearContents
- For Each sh In Sheets
- If sh.Name <> "汇总" Then
- r = sh.Range("a65536").End(xlUp).Row
- arr = sh.Range("a6:f" & r)
- ReDim brr(1 To r, 1 To 6)
-
- For r = 1 To UBound(arr)
- brr(r, 1) = arr(r, 1)
- brr(r, 2) = brr(r, 2) + arr(r, 2)
- brr(r, 3) = arr(r, 3)
- brr(r, 4) = brr(r, 4) + arr(r, 4)
- brr(r, 5) = arr(r, 5)
- brr(r, 6) = brr(r, 4) + arr(r, 6)
- Next
-
- End If
- Next sh
- With S1
- S1.Range("a6").Resize(20, 6) = brr
- End With
- End Sub
复制代码
2011年结算表.rar
(14.39 KB, 下载次数: 11)
|