|
以下是代码,怎么改成实时统计计算的代码呢
Sub test11()
Dim d As Object
Dim rs
Dim i As Integer
Dim ar As Variant
Dim br As Variant
Dim m
Set d = CreateObject("scripting.dictionary")
rs = Sheets("学员信息建档").Cells(Rows.Count, 9).End(xlUp).Row
Sheets("学员信息建档").Range("i3:l" & rs) = Empty
ar = Sheets("学员信息建档").[a1].CurrentRegion
For i = 3 To UBound(ar)
If ar(i, 1) <> "" Then
d(ar(i, 1)) = i
End If
Next i
br = Sheets("报名登记").[a1].CurrentRegion
For i = 7 To UBound(br)
m = d(br(i, 2))
If m <> "" Then
ar(m, 9) = ar(m, 9) + br(i, 11)
ar(m, 10) = ar(m, 10) + 1
End If
Next i
ar(3, 11) = UBound(ar) - 2
ar(3, 12) = UBound(br) - 6
Sheets("学员信息建档").[a1].CurrentRegion = ar
End Sub
|
|