|
参与一下。。。
- Sub ykcbf() '//2024.5.8
- Set d = CreateObject("Scripting.Dictionary")
- With Sheets("条件数据")
- r = .Cells(Rows.Count, 1).End(3).Row
- arr = .[a1].Resize(r, 1)
- End With
- For i = 2 To UBound(arr)
- s = CStr(arr(i, 1))
- d(s) = ""
- Next
- With Sheets("数据源")
- r = .Cells(Rows.Count, 1).End(3).Row
- arr = .[a1].Resize(r, 4)
- End With
- ReDim brr(1 To r, 1 To 4)
- For i = 2 To UBound(arr)
- s = CStr(arr(i, 4))
- If d.exists(s) Then
- m = m + 1
- For j = 1 To UBound(arr, 2)
- brr(m, j) = arr(i, j)
- Next
- End If
- Next
- With Sheets("结果表")
- .UsedRange.Offset(1).ClearContents
- .Columns(4).NumberFormatLocal = "@"
- .[a2].Resize(m, 4) = brr
- .[a2].Resize(m, 4).Borders.LineStyle = 1
- End With
- Set d = Nothing
- MsgBox "OK!"
- End Sub
复制代码
|
|