I have an Excel sheet that tracks Action Items
I wrote a formula that each time an Action Item is Over Due the status changes to "Over Due"
I need a macro that will recognize that automatically and will copy the specific row and send an email to the person responsible for this Action Item with a message "Your Action Item is Over Dueâ¦.."
You can find the Excel sheet in ftp://dannyn:email@example.com/
Can you please help?