|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub gj23w98()
- Set d = CreateObject("Scripting.Dictionary")
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- For Each sht In Sheets
- If sht.Name <> "花名册" And sht.Name <> "花名册模板" Then sht.Delete
- Next
- Application.DisplayAlerts = True
- arr = [a1].CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To 11)
- For i = 2 To UBound(arr)
- d(arr(i, 8)) = ""
- Next
- k = d.keys
- For i = 0 To UBound(k)
- m = 0
- For n = 1 To UBound(arr)
- If arr(n, 8) = k(i) Then
- m = m + 1
- brr(m, 1) = m
- brr(m, 2) = arr(n, 1)
- brr(m, 3) = arr(n, 2)
- brr(m, 4) = arr(n, 4)
- brr(m, 5) = arr(n, 3)
- brr(m, 6) = arr(n, 5)
- brr(m, 7) = arr(n, 13)
- brr(m, 8) = arr(n, 6)
- For j = 9 To 11
- brr(m, j) = arr(n, j)
- Next
- End If
- Next
- Sheets("花名册模板").Copy After:=Sheets(Worksheets.Count)
- With ActiveSheet
- .Name = k(i)
- .[c4] = k(i)
- .[a6].Resize(m, 11) = brr
- End With
- Sheets("花名册").Activate
- Next
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码 |
|