I used the McGimpsey code, and it worked, until I protected the sheet, then
it quit working entirely. I unprotected the 2 columns in the formula, but it
made no difference. Is there a trick to using it in a protected sheet?
Richard
"Dave Peterson" wrote:
J.E. McGimpsey shows a way to put a time stamp on the same row when something
changes:
http://www.mcgimpsey.com/excel/timestamp.html
Qlychap wrote:
Hi all,
I am using office 2003; I am trying to fix up a automated time tracking
system.
I like to find when the particular field is updated in the excel and
update the same in the adjacent row. Let me give you a example
Field A5 will be filled as Yes / No I want the A6 to be filled with the
date and time of the field A5 got updated
I tried with this formula: *@ A6 *I typed -=
IF(ISBLANK(A5)=FALSE,NOW()," ")
but the problem is this when ever I save the excel the A6 is getting
updated with the current time.
With regards
Pradeep
--
Qlychap
------------------------------------------------------------------------
Qlychap's Profile: http://www.excelforum.com/member.php...o&userid=35253
View this thread: http://www.excelforum.com/showthread...hreadid=550268
--
Dave Peterson