Morning,
I have the attached worksheet that automatically sends an email when a contract is past its expiry date, only got it to work for the top line so far so need some help altering the macro to work when I have subsequent lines underneath. Please see attached.
Many thanks
Jason
Contract expiry test.xls
Bookmarks