Excel // VBA / / Macro // Code needed to set a date in a cell in the contents of another cell changes

[Evremonde]

Hello All:

I have a spreadsheet and I need some VBA assistance. I think this is easy but we shall see. Cells E2 through E1000 may contain either OP or GS. On initial data entry, the contents of the range will be set to either OP or GS (data entry will start at E2 and proceed to E3, E4, Etc as need). After initial data entry, the contents of the range may be changed from OP to GS - or - from GS to OP. If this occurs, I need to set the date of change in another column on the same row (not sure which column yet). Any VBA code to perform this function would be appreciated.

 

[Momentman]

Try something like this
1. Right click on the worksheet tab(the worksheet with the data
2. Select "View Code"
3. Paste the following code in there

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("E2:E1000")) Is Nothing Then
        Range("Z" & Target.Row).Value = Time
    End If
End Sub

It updates the date in column Z

 

[Evremonde]

Thank you my friend. This works perfectly...

 

[Momentman]

Thank you my friend. This works perfectly...

You are welcome