Thread: Insert DATE if any Cell in Row changed

I have a spreadsheet of Sales Funnel data where columns A through J are typical sales fielded information.

I'd like to use column L to insert a DATE if any of the cells on that row in columns A-J are changed/update by sales personnel.

I'd appreciate tips from learned excel programmers.

You're correct that this will require VBA. Which means this probably should have been posted in the Programming forum. Oops.

Right-click the sheet tab and select VIEW CODE, then paste in this macro:

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range

For Each cell In Target
    If Not Intersect(cell, Range("A:J")) Is Nothing Then
        If cell <> "" Then
            Application.EnableEvents = False
            Range("L" & cell.Row) = Date
            Application.EnableEvents = True
        End If
    End If
Next cell

End Sub

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.