Forum Discussion
SKight
Feb 16, 2022Copper Contributor
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.
NikolinoDE
Feb 17, 2022Platinum Contributor
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 SubHope I could help you with these information.
I know I don't know anything (Socrates)