Private Sub Worksheet_Change(ByVal Target As Range)
Dim x
If Target.Address <> "$H$6" Then End
For Each x In [d6:f6]
If x = Target Then
Application.EnableEvents = False
Target.Offset(0, 1) = x.Offset(1, 0)
Application.EnableEvents = True
Exit For
End If
Next
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim x
If Target.Address <> "$H$6" Then End
For Each x In [d6:f6]
If x = Target Then
Application.EnableEvents = False
Target.Offset(0, 1) = x.Offset(1, 0)
Application.EnableEvents = True
Exit For
End If
Next
End Sub