Change Date in Cell base on another cell

Copper Contributor

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. 

1 Reply

@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)