|
Sub 筛选结果()
Dim dic, jg()
Set dic = CreateObject("scripting.dictionary")
For i = 2 To Sheet2.Range("A" & Rows.Count).End(xlUp).Row
dic(Sheet2.Cells(i, 1).Value & "|" & Sheet2.Cells(i, 2).Value) = ""
Next
arr = Sheet1.[a1].CurrentRegion
ReDim jg(1 To UBound(arr), 1 To UBound(arr, 2))
For i = 2 To UBound(arr)
关键字 = arr(i, 1) & "|" & arr(i, 2)
If dic.exists(关键字) Then
k = k + 1
For j = 1 To UBound(arr, 2)
jg(k, j) = arr(i, j)
Next
End If
Next
Sheet2.[d1].CurrentRegion.Offset(1) = ""
Sheet2.[d2].Resize(k, UBound(arr, 2)) = jg
Set dic = Nothing
End Sub |
|