Forum Discussion

SKight's avatar
SKight
Copper Contributor
Feb 16, 2022

Change Date in Cell base on another cell

I am trying to create a spreadsheet where when a specific cell is updated in anyway, the date stamp automatically updates in the cell to the right is updated. I need to do this to an entire row. 

excel

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Feb 17, 2022

    SKight 

    Here is a VBA approach

    Private Sub Worksheet_Change(ByVal Target As Range)
If Target.CountLarge > 1 Then Exit Sub 'allow only one cell change
If Target.Column = 20 Then
Cells(Target.Row, 21) = IIf(Target = "", "", Date)
Cells(Target.Row, 22) = IIf(Target = "", "", Environ("username"))
End If

End Sub

    Hope I could help you with these information.

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources