Afternoon all
I need to help automate parts of reporting.
If column "P" has a cell that contains Today's date, then I want the value "Delivered" to be in the respective column "V" within the same row.
AND IF column "P" does not contain today's date then it just leaves it as is.
I have the following code but now working for some reason:
Code
Sub Start10_xxxxxxxxxxxxxxxxxxxxx()
'
' Start10_xxxxxxxxxxxxxxxxxxxxx Macro
'
If Int(ActiveSheet.Range("P3").End(xlDown).Select = Date Then ActiveSheet.Range("v3").End(xlDown).Select = "Delivered"
Range("V3").Select
End Sub
Thanks in advance