Excel 2007 : Insert DATE if any Cell in Row changed

[varocketry]

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.

[JBeaucaire]

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

[varocketry]

WOW, GURU is right.
Thanks Jerry

[klickt]

Hello Jerry,
Thankyou.
Sincerely,
Tim

[JBeaucaire]

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