|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 answer6141 于 2020-1-30 10:02 编辑
- Sub test()
- Dim i, j, k, m, n, irow, jrow As Long
- Dim arr, brr, crr
- Dim d1, d2, d3 As Object
- Set d1 = CreateObject("scripting.dictionary")
- Set d2 = CreateObject("scripting.dictionary")
- With Sheets("报名登记")
- irow = .Cells(.Cells.Rows.Count, 1).End(xlUp).Row
- arr = .Range("a7:o" & irow)
- For i = LBound(arr) To UBound(arr)
- d1(arr(i, 2)) = d1(arr(i, 2)) + arr(i, 11) '累计缴费
- d2(arr(i, 2)) = d2(arr(i, 2)) + 1 '次数
- Next
- crr = d1.items
- For k = 0 To UBound(crr)
- Debug.Print crr(k)
- Next
- End With
- With Sheets("学员信息建档")
- jrow = .Cells(.Cells.Rows.Count, 1).End(xlUp).Row
- brr = .Range("a3:l" & jrow)
- brr(1, 10) = UBound(arr, 1)
- brr(1, 11) = UBound(brr, 1)
- For j = 1 To UBound(brr)
- brr(j, 9) = d1(brr(j, 1))
- brr(j, 10) = d2(brr(j, 1))
- Next
- .Range("a3").Resize(UBound(brr, 1), UBound(brr, 2)) = brr
- End With
- End Sub
- 试试这个,有用赏花哦
复制代码 |
评分
-
1
查看全部评分
-
|