Hello,
Can someone help me as I am a novice with VBA.
What I need is, if a static date and time is in one cell(A1) and if I have an automatically updating date and time cell in another(A2) and (A2) passes the static date and time of (A1), send an email as a alert.
It will be used as an alert for equipment to be changed over after its use-by date. Excel will be open and run in the background 24/7 so there is no need to call it up
The email needs to be basic just to alert me that a certain piece of equipment needs changing.
Your help would be greatly appreciated
Can someone help me as I am a novice with VBA.
What I need is, if a static date and time is in one cell(A1) and if I have an automatically updating date and time cell in another(A2) and (A2) passes the static date and time of (A1), send an email as a alert.
It will be used as an alert for equipment to be changed over after its use-by date. Excel will be open and run in the background 24/7 so there is no need to call it up
The email needs to be basic just to alert me that a certain piece of equipment needs changing.
Your help would be greatly appreciated
