|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
参与一下。。。
- Sub ykcbf() '//2024.4.8
- Dim arr, d
- Application.ScreenUpdating = False
- Set d = CreateObject("Scripting.Dictionary")
- With Sheets("表1")
- st = .[b2] & "|" & .[c2] & "|" & .[d2]
- End With
- With Sheets("表2")
- r = .Cells(.Rows.Count, "a").End(xlUp).Row
- arr = .[a1].Resize(r, 6)
- End With
- ReDim brr(1 To 1000, 1 To 1)
- For i = 2 To UBound(arr)
- s = arr(i, 4) & "|" & Month(arr(i, 3)) & "|" & Day(arr(i, 3))
- ss = arr(i, 6)
- If s = st Then
- If Not d.exists(ss) Then
- m = m + 1
- d(ss) = m
- brr(d(ss), 1) = arr(i, 6)
- End If
- End If
- Next
- With Sheets("表1")
- .[a4:b1000] = ""
- .[a4].Resize(m, 1) = brr
- End With
- Set d = Nothing
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|