|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Sub 汇总()
Application.ScreenUpdating = False
Dim ar As Variant
Dim i As Long, r As Long
Dim br()
Dim d As Object
ReDim br(1 To 50000, 1 To 7)
Set d = CreateObject("scripting.dictionary")
For Each sh In Sheets
If InStr(sh.Name, "月") > 0 Then
r = sh.Cells(Rows.Count, 1).End(xlUp).Row
ar = sh.Range("a1:i" & r)
For i = 2 To UBound(ar)
If Trim(ar(i, 1)) <> "" Then
t = d(Trim(ar(i, 1)))
If t = "" Then
k = k + 1
d(Trim(ar(i, 1))) = k
t = k
br(k, 1) = ar(i, 1)
br(k, 2) = ar(i, 2)
br(k, 3) = ar(i, 6)
br(k, 4) = ar(i, 3)
br(k, 5) = ar(i, 4)
br(k, 6) = ar(i, 7)
End If
br(t, 7) = br(t, 7) + ar(i, 9)
End If
Next i
End If
Next sh
With Sheets("汇总")
.[a1].CurrentRegion.Offset(1) = Empty
.[a2].Resize(k, UBound(br, 2)) = br
End With
Application.ScreenUpdating = True
MsgBox "ok!"
End Sub
|
评分
-
1
查看全部评分
-
|