|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Private Sub Worksheet_Activate()
- Set d = CreateObject("scripting.dictionary")
- Application.ScreenUpdating = False
- arr = Sheets("报名登记").UsedRange
- brr = Sheets("报名登记").UsedRange
- r = 0
- br = 0
- For j = 7 To UBound(arr)
- If arr(j, 12) = "返学费" Then
- br = br + 1
- brr(br, 1) = Format(arr(j, 1), "yyyy/mm/dd")
- brr(br, 2) = arr(j, 9)
- brr(br, 3) = arr(j, 3)
- brr(br, 4) = arr(j, 4)
- brr(br, 5) = arr(j, 2)
- brr(br, 6) = arr(j, 5)
- brr(br, 7) = arr(j, 6)
- brr(br, 8) = arr(j, 10)
- brr(br, 9) = arr(j, 11)
-
- If d.exists(arr(j, 9) & "") Then
- x = d(arr(j, 9) & "")
- arr(x, 4) = arr(x, 4) + arr(j, 11)
- Else
- r = r + 1
- d(arr(j, 9) & "") = r
- arr(r, 1) = arr(j, 6)
- arr(r, 2) = arr(j, 5)
- arr(r, 3) = arr(j, 9)
- arr(r, 4) = arr(j, 11)
- End If
- End If
- Next j
- ActiveSheet.UsedRange.Offset(2).ClearContents
- If r > 0 Then
- [k3].Resize(r, 4) = arr
- [a3].Resize(br, 9) = brr
- End If
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|