Good Morning,
We have a spreadsheet of a master supplier list. In the list in the range R5:R26 we have a contract date.
In cell range S5:S65 we have the following formula =IF(R14<(TODAY()+7),"<<<","") for example.
Now what I need is when the formula triggers the arrows do to a contract date coming close to expiry I need it to email my manager to let her know to check the spreadsheet for which vendor needs contract review. Vendors are listed in range B5:B65.
Hopefully in the email I can list the vendor that needs contract review to avoid having to go into the spreadsheet.
I need this done automatically.
Any help with this would be greatly appreciated.
Thanks!