Date

[ExcelRoy]

hello,

could you please help me out once again.

this time i have the following problem with excel

i need a date to be shown when entering data

eg. A2 i enter a part number and B2,C2,D2 have other information in

i would like cell E2 to automatically show that current date ie(05/10/06)

BUT

when i open the spreadsheet next time i would like 05.10.06 to remain on those lines i entered then and any new lines i enter now i would like the new date to be shown

i tried =NOW() but this only shows the date when i open the spreadsheet

Kind regards

ExcelRoy

 

[Border Terrier]

Not sure if this is the sort of thing you are after, but give it a try.
Took this from something similar to your own sheet, there may well be a simpler way, but this works ok for me.

Private Sub Worksheet_Change(ByVal Target As Range)
For Each Chged In Target
If (Chged.Column = 1) Then
If (Chged.Row > 1) Then
If (Chged = "") Then
Chged.Offset(, 1) = ""
Else
Chged.Offset(, 4) = " " & Format(Now(), "d/m/yyyy")
End If
End If
End If
Next
End Sub


Hope it's of some help.
Simon