KOsborn_13
New Member
- Joined
- Oct 20, 2017
- Messages
- 4
Hello. I'm brand new to the forum and have been "lurking" for a solution to my problem for a while. This subject has been discussed to a certain degree on other threads and I'm sorry if I'm reopening old wounds.
I have a worksheet that my company uses as a form. On that form, there are password protected cells that can be unlocked only by select users so that they may provide an electronic signature. Cell AF2 contains =now().
I'd like to have the "form" enter the date the electronic signature cell is modified in the adjacent cell to that persons signature.
Specifically, when cell K18 is modified by adding a signature, I'd like the date stamp to automatically appear in M18.
Subsequently, when K29 is modified, the date stamp in M29; when I37 is modified, the date stamp in T37; and finally, when I40 is modified, the date stamp in T40.
I have read that if I copy and past the =now(), it will "lock" on the date/time... but I'd like this to happen automatically when the modification is made.
I have a worksheet that my company uses as a form. On that form, there are password protected cells that can be unlocked only by select users so that they may provide an electronic signature. Cell AF2 contains =now().
I'd like to have the "form" enter the date the electronic signature cell is modified in the adjacent cell to that persons signature.
Specifically, when cell K18 is modified by adding a signature, I'd like the date stamp to automatically appear in M18.
Subsequently, when K29 is modified, the date stamp in M29; when I37 is modified, the date stamp in T37; and finally, when I40 is modified, the date stamp in T40.
I have read that if I copy and past the =now(), it will "lock" on the date/time... but I'd like this to happen automatically when the modification is made.