|
- Sub 汇总()
- Set d = CreateObject("scripting.dictionary")
- ReDim arr(1 To Sheets.Count + 1, 1 To 100)
- r = UBound(arr)
- arr(1, 1) = "月份": arr(r, 1) = "合计"
- n = 1
- For i = 2 To r - 1
- With Sheets(i)
- arr(i, 1) = .Name
- cmax = .[iv2].End(xlToLeft).Column - 1
- For j = 1 To cmax
- s = Trim(.Cells(2, j))
- If Not d.exists(s) Then n = n + 1: d(s) = n: arr(1, n) = s
- arr(i, d(s)) = .Cells(3, j)
- arr(r, d(s)) = arr(r, d(s)) + .Cells(3, j)
- Next
- End With
- Next
- [a2].Resize(UBound(arr), n) = arr
- Cells(2, n + 1) = "合计"
- For i = 2 To r
- Cells(i + 1, n + 1).Formula = "=sum(rc2:rc[-1])"
- Next
- End Sub
复制代码 |
评分
-
查看全部评分
|