|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub 分班信息()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim d1 As New Dictionary, d2 As New Dictionary, arr, brr, m%
For Each sht In Sheets
If sht.Name Like "*班" Then
sht.Delete
End If
Next
arr = Sheets("考生信息").Range("A1").CurrentRegion
For i = 2 To UBound(arr)
d1(Mid(arr(i, 1), 5, 2)) = ""
d2(Mid(arr(i, 1), 5, 2) & arr(i, 2)) = i
Next
With Sheets("各班考生信息")
For Each k In d1.Keys
s = Filter(d2.Keys, k): .[d1] = Val(k)
ReDim brr(1 To 100, 1 To 6)
For Each c In s
m = m + 1
brr(m, 1) = m
For j = 2 To UBound(brr, 2)
brr(m, j) = arr(d2(c), j - 1)
Next
Next
.Copy after:=Sheets(Sheets.Count)
Sheets(Sheets.Count).[a3].Resize(m, 6) = brr
Sheets(Sheets.Count).[a3].Resize(m, 6).Borders.LineStyle = 1
ActiveSheet.Name = .[d1] & "班": m = 0
.[d1] = ""
Next
End With
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
|
评分
-
1
查看全部评分
-
|