本帖最后由 冥王 于 2015-6-10 10:45 编辑
Sub demo()
Dim d As Object
Dim arr, brr, i%, j%, crr(1 To 30000, 1 To 1)
Set d = CreateObject("scripting.dictionary")
With ThisWorkbook
arr = .Sheets(1).Range("A1").CurrentRegion
brr = .Sheets(2).Range("A1").CurrentRegion
For i = LBound(brr, 1) + 1 To UBound(brr, 1)
d(brr(i, 4)) = brr(i, 1)
Next
For j = LBound(arr, 1) + 1 To UBound(arr, 1)
If d(arr(j, 2)) <> "" And arr(j, 1) > d(arr(j, 2)) Then
crr(j - 1, 1) = "不需要"
Else
crr(j - 1, 1) = ""
End If
Next
.Sheets(1).Cells(2, "L").Resize(UBound(arr, 1) - 1, 1) = crr
End With
End Sub