|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
'我还以为就B列汇总,已修改,,,
Option Explicit
Sub test()
Dim arr, i, j, m, sum, n
arr = Sheets("数据").[a1].CurrentRegion.Offset(2)
ReDim brr(1 To UBound(arr, 1), UBound(arr, 2)), sum(2 To UBound(arr, 2))
For i = 1 To UBound(arr, 1) - 2
For j = 2 To UBound(arr, 2): sum(j) = sum(j) + arr(i, j): Next
If i Mod 7 = 0 Or i = UBound(arr, 1) - 2 Then
m = m + 1: n = n + 1
brr(m, 0) = Format(n, "第0周"): brr(m, 1) = arr(i, 1)
For j = 2 To UBound(sum): brr(m, j) = sum(j): Next
ReDim sum(2 To UBound(arr, 2))
End If
Next
With Sheets("结果").[a3]
.Resize(Rows.Count - 2, UBound(brr, 2) + 1).ClearContents
.Resize(m, UBound(brr, 2) + 1) = brr
End With
End Sub |
评分
-
1
查看全部评分
-
|