Hi all,
Hope all are well.
In attached file, i want the current date and time to be captured once a macro is run.
In sheet "Open", current date and time to be captured in cell C2 once the macro "RunAllOpenMacros" is run.
In sheet "Closed", current date and time to be captured in cell C2 once the macro "RunAllClosedMacros" is run.
Note:
1. Same cell C2 should be replaced with new date and time when the macro is run the next time.
2. Date and time format should be as 01-Apr-2023, 03:30 PM
3. Pass: Abc@123
Can someone please help?
Thank you
Bookmarks