| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a cell be changed on a certain date | Excel Discussion (Misc queries) | |||
| STORE THE DATE & TIME THE VALUE HAS CHANGED IN A CELL | Excel Discussion (Misc queries) | |||
| Insert date when a cell is changed | Excel Discussion (Misc queries) | |||
| can i see the date the last time a cell was changed? | New Users to Excel | |||
| Code - if T changed, change date in W to date it is changed | Excel Programming | |||
![Gavin Ling[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
