|
在3楼- Sub Macro1()
- Dim arr, brr, crr, drr, d, i&, j&, k&, zf$$
- Set d = CreateObject("scripting.dictionary")
- arr = Sheet1.Range("a1").CurrentRegion
- brr = Sheet2.Range("a1").CurrentRegion
- crr = Sheet3.Range("a1").CurrentRegion
- ReDim drr(1 To UBound(arr), 1 To UBound(arr, 2))
- For i = 4 To UBound(arr)
- zf = arr(i, 2) & "," & arr(i, 3)
- d(zf) = i
- Next
- For i = 1 To UBound(brr)
- For j = 1 To UBound(crr)
- zf = brr(i, 1) & "," & crr(j, 1)
- s = s + 1
- If d.exists(zf) Then
- n = d(zf)
- For k = 1 To UBound(arr, 2)
- drr(s, k) = arr(n, k)
- Next
- Else
- For k = 1 To UBound(arr, 2)
- drr(s, k) = "NC"
- Next
- drr(s, 2) = brr(i, 1): drr(s, 3) = crr(j, 1)
- End If
- Next
- Next
- Sheet4.Activate
- ActiveSheet.UsedRange.Clear
- Sheet1.[a1].Resize(2, UBound(arr, 2)).Copy [a1]
- [a3].Resize(s, UBound(drr, 2)) = drr
- End Sub
复制代码 的代码上改了一下。 |
|