Hello,
I am trying to make a 30-Day rolling schedule based on dates for a delivery schedule. I want to be able to delete the rows that show "False" to an =AND statement I wrote if their delivery date is outside my 30-Day rolling calendar.
The AND statement is =AND(D2>=$J$3,D2<=$K$3)
Where;
- D2 is delivery date
- J3 Is =Today()
- K3 is +Today()+30
This statement returns false if that date(D2) is outside of my 30 day range, does anyone know of a formula or code in VBA that will delete entire rows if there is a column containing a text string?
-Cheers
I am trying to make a 30-Day rolling schedule based on dates for a delivery schedule. I want to be able to delete the rows that show "False" to an =AND statement I wrote if their delivery date is outside my 30-Day rolling calendar.
The AND statement is =AND(D2>=$J$3,D2<=$K$3)
Where;
- D2 is delivery date
- J3 Is =Today()
- K3 is +Today()+30
This statement returns false if that date(D2) is outside of my 30 day range, does anyone know of a formula or code in VBA that will delete entire rows if there is a column containing a text string?
-Cheers