Feb 16 2022 05:34 AM
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.
Feb 17 2022 03:28 AM
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.
I know I don't know anything (Socrates)