You can use a worksheet change macro like the one below

Private Sub worksheet_Change(ByVal target As Range)

If target.Column = 6 Then
Cells(target.Row + 1, "A").Select
End If

End Sub


"Kindlysinful" wrote:

Hello,
I have office 2004 for Mac and am trying to make it so that when you get to
the end of the row of data entry and hit enter the next active cell is the
first one that you started with.
IE: cells a1, b1, c1, d1, e1, f1... are data entry cells and what I would
like is when the last data point was entered into f1 and "enter" was hit,
excel would automatically return to a1.

Thanks,
Scott