auto carriage return

David
This can, of course, be done with a VBA event procedure but it is also possible with just keyboard input :-
Go to Tools/Options…/Edit/Move Selection After Enter and select Direction : Down.
Assuming you want to input data into row 1 of columns A,B, & C and then row 2 et sequitor :-
Input in A1,tab to B1,input in B1 and tab to C1, input to C1 and press the enter key which will take you to cell A2.
Celia

The keyboard input is good but I have a template that
we use to enter data and we are in the habbet of using the enter key
to move to the next cell, and when we move to the next row
we need to start in column "b"
Any tips on the vba macro?

David
If you want to move to column B of the next row after entering column F :-

Private Sub Worksheet_Change(ByVal Target As Range)
Dim endCol As Range, startCol As Range
Set endCol = Range("F:F")
Set startCol = Range("B:B")
If Not Application.Intersect(endCol, Range(Target.Address)) Is Nothing Then Cells(ActiveCell.Row + 1, startCol.Column).Select
End Sub

Celia

Celia,
Thank you so much. That is just what I have beed looking for.