Using VBA to change a value in one column based on another

So I have my worksheet that has some dates on it - namely date response due.
There is a column which indicates the status of an application for a business: application received, active, and inactive.

I already have it set up that overdue application are highlighted in red, but I was also looking for a macro which would change the text in the status column to OVERDUE when the due date is reached and passed.

I was wondering what would be the best way to code this.

Something along the lines of --> search column K by row. If the date is less than today then change the value in column D to OVERDUE.

.
Paste this formula in D2 and drag down the column as far as required.

Please Login or Register  to view this content.

Originally Posted by Logit

.
Paste this formula in D2 and drag down the column as far as required.

Please Login or Register  to view this content.

This didn't work out for me, applying the formula over existing entries removes them (anything nnot overdue becomes a blank cell, remembers, items are already labelled as received, active, or inactive)
If the formula is applied first, and then an entry is made, it messes up the conditional formatting and does not work.

I was looking for a vba macro specifically to avoid issues with cell forumlas.

.
Paste this macro into a Routine Module :

Please Login or Register  to view this content.

Originally Posted by Logit

.
Paste this macro into a Routine Module :

Please Login or Register  to view this content.

Thankyou this is exactly what I was looking for, I did a little bit of editing to have it initiate when the workbook opens

.
Glad it works. You are welcome.