|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Sub test()
With Sheets("台账")
'r = .Cells(Rows.Count, 1).End(xlUp).Row
r = .Cells(2, 1).End(xlDown).Row
.Range("c3:c" & r) = Empty
ar = .Range("a1:c" & r)
'rs = .Cells(Rows.Count, 6).End(xlUp).Row
rs = .Cells(2, 6).End(xlDown).Row
br = .Range("f1:h" & r)
For i = 3 To UBound(ar)
For s = 3 To UBound(br)
If Trim(ar(i, 2)) = Trim(br(s, 2)) And DateValue(ar(i, 1)) > DateValue(br(s, 1)) And br(s, 3) > 0 Then
ar(i, 3) = br(s, 1)
End If
Next s
Next i
.Range("a1:c" & r) = ar
End With
End Sub
|
|