把空值标注出来了。
Public Sub 比对数据()
Dim arr, brr, i, j, h
Application.ScreenUpdating = False
brr = Sheet1.Range("A2:D" & Sheet1.[B65536].End(3).Row)
arr = Sheet2.Range("A2:D" & Sheet2.[B65536].End(3).Row)
For j = 1 To UBound(arr)
h = 0
For i = 1 To UBound(brr)
If brr(i, 4) = "已处理" And arr(j, 1) = brr(i, 1) Then
arr(j, 4) = "已处理"
arr(j, 3) = ""
h = 1
End If
If arr(j, 1) = brr(i, 1) And arr(j, 4) <> "已处理" Then
If arr(j, 3) = "" Then
arr(j, 3) = brr(i, 3)
Else
If arr(j, 3) > brr(i, 3) Then
arr(j, 3) = brr(i, 3)
End If
End If
h = 1
End If
Next
If h = 0 Then
arr(j, 3) = "空值"
End If
Next
Sheet2.Range("C2").Resize(UBound(arr)) = Application.WorksheetFunction.Index(arr, 0, 3)
Erase arr, brr
MsgBox "OK"
Application.ScreenUpdating = True
End Sub
最近日期提取.zip
(15.9 KB, 下载次数: 6)
|