Put this code into *Sheet1 Module*
Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Count = 1 Then
If .Column = 8 Then Target(1, 2).Activate
If .Column = 9 Then Target(2, 0).Activate
End If
End With
End Sub
' this macro run in column H and column I of S
I need a macro that will move the curser in a specific pattern of; Right one
cell the first time, and down one and left one the second time and then
repeat.
It would save a lot of time entering the data in two side by side columns so
I need it to not be column specific (so I could use it in any tw