Timestamp that want change when workbook is opened

[George T]

I trying to create a timestamp for cell A12 when data is entered into C12, but I need this time to be locked and not change when workbook is closed and reopened.

 

[Joe4]

Sounds like you want to use a Worksheet_Change event procedure, which is VBA code which is automatically triggered upon some event happening (like the update of a specific cell).

Right click on the sheet tab name at the bottom and select "View Code" and paste the following VBA code in the resulting VB Editor window:

Private Sub Worksheet_Change(ByVal Target As Range)
 
'   Automatically place date/time stamo in cell A12 when C12 is manually updated
    If Target.Address = "$C$12" Then
        Target.Offset(0, -2) = Now
    End If
 
End Sub

Now, go back to your sheet and change the entry in cell C12 and see A12 update.

For more on event procedures, check out this link: http://www.cpearson.com/excel/Events.aspx

 

[Joe4]

Quote from PM: <!-- / icon and title --><!-- message -->

Thanks for help How can I get this to same for cell C12 THUR C100 and A12 THUR A100.

This modification should do that:

 Private Sub Worksheet_Change(ByVal Target As Range)
 
' Automatically place date/time stamp in cells A12:A100 when a cell in C12:C100 is manually updated
    If Not Intersect(Target, Range("C12:C100")) Is Nothing Then
        Target.Offset(0, -2) = Now
    End If
 
End Sub