sanchit16
New member
Please help me out in creating simple but tricky macro.
I need to compare real time/pc time with the time present in the sheet column 'e'. With a alert message when it crosses the time.
"note: I dnt need any trigger or button to run it i need that when i open the sheet it automatically start checking the time and when the time crosses it genrate the alert ."
all the requirements are mentioned in the attached sheet.[pfa]
hope someone can help me out.
I need to compare real time/pc time with the time present in the sheet column 'e'. With a alert message when it crosses the time.
"note: I dnt need any trigger or button to run it i need that when i open the sheet it automatically start checking the time and when the time crosses it genrate the alert ."
all the requirements are mentioned in the attached sheet.[pfa]
hope someone can help me out.