Forum Discussion

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

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)