Automatically adding the date/time to a cell when another cell is updated

iamirenemae 

If you want the timestamp to be static and not update every day, you can use a combination of VBA (Visual Basic for Applications) and a worksheet event. The VBA code will be triggered whenever the specified cells are changed, and it will insert a timestamp in the cell below the updated cell.

Here's a step-by-step guide:

1. Press Alt + F11 to open the Visual Basic for Applications editor.
2. In the editor, right-click on VBAProject (Your Workbook Name) in the left pane.
3. Choose Insert -> Module to insert a new module.
4. Copy and paste the following VBA code into the module:

Vba code:

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Worksheets("Sheet1") ' Replace "Sheet1" with your sheet name

    Dim updatedCell As Range
    Set updatedCell = Intersect(Target, ws.Range("A1:E1")) ' Adjust the range as needed

    If Not updatedCell Is Nothing Then
        Application.EnableEvents = False
        updatedCell.Offset(1, 0).Value = Now
        Application.EnableEvents = True
    End If
End Sub

5. Close the VBA editor.

Make sure to replace "Sheet1" with the actual name of your sheet, and adjust the range in the Intersect function to match the range of cells you want to monitor.

Now, whenever any cell in the specified range is updated, the cell below it will be populated with the current date and time. The timestamp will not automatically update daily; it will remain static once entered.