|
在审核...
Dim r%, i%
Dim arr, brr
Dim d(1 To 4) As Object
For i = 1 To 4
Set d(i) = CreateObject("scripting.dictionary")
Next
With Sheet1
r1 = .Cells(.Rows.Count, 1).End(xlUp).Row
r2 = .Cells(.Rows.Count, 2).End(xlUp).Row
r3 = .Cells(.Rows.Count, 3).End(xlUp).Row
r4 = .Cells(.Rows.Count, 4).End(xlUp).Row
r = Application.Max(r1, r2, r3, r4)
arr = .Range("a2:d" & r)
For j = 1 To 4
For i = 1 To UBound(arr)
d(j)(arr(i, j)) = ""
Next
Next
End With
With Sheet3
r = .Cells(.Rows.Count, 1).End(xlUp).Row
arr = .Range("a2:b" & r)
ReDim brr(1 To UBound(arr), 1 To 4)
For j = 1 To 4
m = 0
For i = 1 To UBound(arr)
If Not d(j).exists(arr(i, 1)) Then
m = m + 1
brr(m, j) = arr(i, 1)
End If
Next
Next
End With
With Sheet2
' .UsedRange.Offset(1, 0).ClearContents
.Range("a2").Resize(UBound(brr), UBound(brr, 2)) = ""
.Range("a2").Resize(UBound(brr), UBound(brr, 2)) = brr
End With
End Sub
|
评分
-
1
查看全部评分
-
|