|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
参与一下。。。
- Sub ykcbf() '//2024.5.27
- Application.ScreenUpdating = False
- Set d = CreateObject("Scripting.Dictionary")
- fn = [{"今年","前年"}]
- yf = Sheets("月份数据查询").[c2].Value
- Sheets("月份数据查询").[b5:h10000] = ""
- For x = 1 To UBound(fn)
- With Sheets(fn(x))
- r = .Cells(Rows.Count, 1).End(3).Row
- arr = .[a1].Resize(r, 9)
- End With
- d.RemoveAll
- m = 0
- ReDim brr(1 To 10000, 1 To 3)
- For i = 3 To UBound(arr)
- If Month(arr(i, 2)) = Val(yf) Then
- s = arr(i, 1)
- If Not d.exists(s) Then
- m = m + 1
- d(s) = m
- brr(m, 1) = arr(i, 1)
- Else
- r = d(s)
- brr(r, 2) = brr(r, 2) + 1
- brr(r, 3) = brr(r, 3) + arr(i, 8)
- End If
- End If
- Next
- Sheets("月份数据查询").Cells(5, 4 * x - 2).Resize(m, 3) = brr
- Next
- Set d = Nothing
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
4
查看全部评分
-
|