|
或者按你的宏修改:
Sub test2()
Dim i&, j&, Myr&, Arr, brr()
Dim d, k, t
Set d = CreateObject("Scripting.Dictionary")
Myr = Sheet2.[a65536].End(xlUp).Row
Arr = Sheet2.Range("a3:b" & Myr)
For i = 1 To UBound(Arr)
d(Arr(i, 1)) = d(Arr(i, 1)) + 1
d(Arr(i, 1) & d(Arr(i, 1))) = Arr(i, 2)
Next
Myr = Sheet2.[a65536].End(xlUp).Row
Arr = Sheet2.Range("d4:d" & Myr)
CRR = Range("E3:Z3") '班级
ReDim brr(1 To UBound(Arr), 1 To UBound(CRR, 2))
For i = 1 To UBound(Arr)
For j = 1 To UBound(CRR, 2)
brr(i, j) = d(CRR(1, j) & Arr(i, 1))
Next
Next
Range("e4:iv1000").ClearContents
Range("e4").Resize(UBound(brr), UBound(brr, 2)) = brr
Set d = Nothing
End Sub |
|