|
发表于 2014-11-19 16:22
|
显示全部楼层
本楼为最佳答案
雄鹰2013 发表于 2014-11-19 16:03
是I列一个品名也不写 - Sub demo()
- If Cells(Rows.Count, 9).End(3).Row < 2 Then Exit Sub
- Dim arr, brr, re(), i, x, n, m
- arr = Range("a2:b" & Cells(Rows.Count, 1).End(3).Row).Value
- brr = Range("i1:i" & Cells(Rows.Count, 9).End(3).Row).Value
- ReDim re(1 To UBound(arr), 1 To 2)
- For i = 1 To UBound(arr)
- n = 0
- For x = 2 To UBound(brr)
- If arr(i, 1) = brr(x, 1) Then n = n + 1
- Next
- If n = 0 Then
- m = m + 1
- re(m, 1) = arr(i, 1)
- re(m, 2) = arr(i, 2)
- End If
- Next
- Range("e2:e65536").ClearContents
- Range("E2").Resize(m, 2) = re
- End Sub
复制代码 |
|