Oct 05 2023 04:34 AM
So I have a spreadsheet and whenever column G is updated I would like to put a date timestamp in column P.
Oct 05 2023 07:12 AM
@SanthoshKunder yes I saw that - I've pretty much search this to death in the last 24hours. That particular solution would require me to right a formula on a row by row basis I think. Plus the thread got a bit in depth for me, involved a lot of trial an error for the contributors and didn't look like the issue was resolved.. It's not the succinct answer I'm looking for .
Oct 05 2023 07:40 AM
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Range("G2:G" & Rows.Count), Target) Is Nothing Then
Application.ScreenUpdating = False
Application.EnableEvents = False
Intersect(Range("G2:G" & Rows.Count), Target).Offset(0, 9).Value = Date ' or Now
Application.EnableEvents = True
Application.ScreenUpdating = True
End If
End Sub
Oct 05 2023 07:59 AM
Sorry, what do you mean by that?
Oct 05 2023 08:12 AM
It is VBA code. You can copy it into the worksheet module - my previous reply describes in detail what to do.
Jun 19 2024 10:33 AM
Can this be expanded such that it is possible to put an update date/time in each column within the worksheet? Let's assume the active rows are 8:69, columns start at X and additional columns could be added over time.
Thx!
Jun 19 2024 11:23 AM
What exactly do you mean by "to put an update date/time in each column"?