|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub zz()
Dim d, ar, br, i, j, m, s
Set d = CreateObject("Scripting.Dictionary")
ReDim br(1 To 300000, 1 To 12)
Application.ScreenUpdating = False
For Each sh In Sheets
If sh.Name <> "汇总" Then
ar = sh.Range("AB1:AL" & sh.Cells(sh.Cells.Rows.Count, "ab").End(3).Row)
For i = 10 To UBound(ar)
If ar(i, 1) <> "" Then
s = "" & ar(i, 1)
If d(s) = "" Then
m = m + 1: d(s) = m
br(m, 1) = s
For j = 3 To UBound(br, 2)
br(m, j) = ar(i, j - 1)
Next
Else
For j = 3 To UBound(br, 2)
br(d(s), j) = br(d(s), j) + ar(i, j - 1)
Next
End If
End If
Next
End If
Next
Sheet3.Range("A2").Resize(m, 12) = br
Application.ScreenUpdating = True
End Sub
|
评分
-
1
查看全部评分
-
|