Fluff you kindly wrote the VB code that I have modified with the help of my Niece, that does exactly what I want.
I need it to work with a further 4 cells
It currently populates AN when Cell I4 has a date entered
I would also like it to populate AS, AX,BC and BH
I am wondering if I only want these other cells populated under certain conditions do those conditions need to be included in the VB code, or can that be managed some other way?
See VB Code below
Thank you in advance
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.CountLarge > 1 Then Exit Sub
If Target.Column = 10 Then
If IsEmpty(Target.Value) Then
Range("AN" & Target.Row).Value = ""
Else
Range("AN" & Target.Row).Value = Date
End If
End If
End Sub
I need it to work with a further 4 cells
It currently populates AN when Cell I4 has a date entered
I would also like it to populate AS, AX,BC and BH
I am wondering if I only want these other cells populated under certain conditions do those conditions need to be included in the VB code, or can that be managed some other way?
See VB Code below
Thank you in advance
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.CountLarge > 1 Then Exit Sub
If Target.Column = 10 Then
If IsEmpty(Target.Value) Then
Range("AN" & Target.Row).Value = ""
Else
Range("AN" & Target.Row).Value = Date
End If
End If
End Sub