column last modified formula

[mister_hayman]

So I have a spreadsheet and whenever column G is updated I would like to put a date timestamp in column P.

[#2]

@mister_hayman -https://techcommunity.microsoft.com/t5/excel/date-of-last-modified-for-a-cell/m-p/3690222 

[#3]

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

[#4]

@mister_hayman 

• Right-click the sheet tab.
• Select 'View Code' from the context menu.
• Copy the code listed below into the worksheet module.
• Switch back to Excel.
• Save the workbook as a macro-enabled workbook (*.xlsm).
• Make sure that you allow macros when you open the workbook.

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

[#5]

I don't recognise that end GUI apologies,,,,

[#6]

@mister_hayman 

Sorry, what do you mean by that?

[#7]

The black Powershell looking screencap

[#8]

@mister_hayman 

It is VBA code. You can copy it into the worksheet module - my previous reply describes in detail what to do.

[#9]

@HansVogelaar 

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!

[#10]

@Mel_in_Tx 

What exactly do you mean by "to put an update date/time in each column"?