|
Sub test()
Dim d As Object, ar, br, cr, i As Integer, bRow As Long
Dim aRow As Long, n As Long
Set d = CreateObject("Scripting.Dictionary")
With Sheets("sheet2")
aRow = .Cells(Rows.Count, 1).End(xlUp).Row
bRow = .Cells(Rows.Count, 2).End(xlUp).Row
ar = .Range("A2:A" & aRow).Value
br = .Range("B2:B" & bRow).Value
End With
For i = 1 To UBound(br)
d(br(i, 1)) = ""
Next
ReDim cr(UBound(ar), 1 To 1)
For i = 1 To UBound(ar)
If Not d.exists(ar(i, 1)) Then
cr(n, 1) = ar(i, 1)
n = n + 1
End If
Next
Sheets("sheet2").Cells(2, "F").Resize(n, 1) = cr '核对你想要结果是否这样,是的话输入到你想要的表格即可
End Sub
|
|