Place date stamp in cell based on adjacent cell value

[weavera]

Hi There,

Can anybody help with this please...


I'm using Excel 2010 on XP 32bit laptop.

I need to get a macro that will place the date in column "M" if column "L" has the text "Closed" in it. The date has to be the date that the "closed" text was applied to column "M" and should't change unless "M" is changed.

The top 4 rows are headers & waffle. The data starts in row 5.

Thanks in advance for reading. Any help is very much appreciated.

 

[VoG]

Right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 12 And Target.Row > 4 Then
    Application.EnableEvents = False
    If Target.Value = "Closed" Then Target.Offset(, 1).Value = Date
    Application.EnableEvents = True
End If
End Sub

 

[weavera]

Thanks for so much for that...It didn't do anything though. Any other thoughts...Sorry to be a pain!

 

[VoG]

Works here. It has to go in the sheet's code module (as described above) and macros must be enabled.

If you type Closed in column L the date should be inserted in column M.