Paste this code:
Below the row:![]()
If Target.Cells.Count = 1 And Target.Column = 16 Then Target.Offset(, 2) = Target Application.EnableEvents = False Target = "" Application.EnableEvents = True End If
and above the row:![]()
Private Sub Worksheet_Change(ByVal Target As Range)
Regards,![]()
End Sub
Antonio
Bookmarks