Hi

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:galit123@194.90.236.210/


Can you please help?

Thanks