formulae advice

[Kevin J Prince]

Greetings
Is there a method or function or formulae that can be written to work on
a cell, so that if a value changes (not looked at but actually changes)
will put in a date into another cell?
Regards

 

[Harald Staff]

Hi Kevin

Your question is very general, but I guess "yes" is an unsatisfying answer.
Rightclick the sheet tab, choose "view code", paste this in:

Private Sub Worksheet_Change(ByVal Target As Range)
With Target(1)
If .Column = 2 Then .Offset(0, 2) = Now
End With
End Sub

Now when you enter stuff in B column of this sheet date/time will be entered
in D column.

HTH. best wishes Harald

 

[JE McGimpsey]

This site

http://www.mcgimpsey.com/excel/timestamp.html

expands on Harald's excellent answer.

 

[Kevin J Prince]

Harald, JEMc|Gimpsey,

Thanks for the answers. Will try them within the hour...

Regards
Kevin