|
Sub 统计()
Dim d As Object
Dim ar As Variant
Dim br()
Dim i As Long
Dim sh As Worksheet
Set d = CreateObject("scripting.dictionary")
ReDim br(1 To 10000, 1 To Sheets.Count)
m = 1: k = 1
For Each sh In Sheets
If sh.Name <> "统计" Then
r = sh.Cells(Rows.Count, 4).End(xlUp).Row
m = m + 1
br(1, m) = sh.Name
ar = sh.Range("d1:d" & 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)
End If
br(t, m) = br(t, m) + 1
End If
Next i
End If
Next sh
With Sheets("统计")
.[a1].CurrentRegion = Empty
.[a1].Resize(k, UBound(br, 2)) = br
End With
MsgBox "ok!", 64, "3190496160 提醒"
End Sub
|
|