Enter the following in Worksheet code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Range("J:J"), Target) Is Nothing Then
Exit Sub
End If
Cells(Target.Row + 1, 1).Select
End Sub

After an entry is made in column 10, we move back to column 1 the next row
down.


REMEMBER: Worksheet code.
--
Gary''s Student
gsnu200711


"Greg" wrote:

lets say I have 10 colums in a worksheet, when in colum 10 of row, i want to
automatically go to colum 1 of row 2