View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gavin Ling[_3_] Gavin Ling[_3_] is offline
external usenet poster
 
Posts: 1
Default Inserting a date when cell is changed


Hi.

I need Excel to insert a date in a certain cell (F26) when another cell
is altered (C7). The trouble is that the date entered in F26 mustn't
change, it must always read as the date when C7 was altered.


I can't seem to make it work without the date constantly changing to
the new day's date.

Gavin


--
Gavin Ling
------------------------------------------------------------------------
Gavin Ling's Profile: http://www.excelforum.com/member.php...o&userid=30110
View this thread: http://www.excelforum.com/showthread...hreadid=512015