Can you set up a "Return" key - like a typewriter?
 

I have over 3000 lines (rows) of data that I need to enter manually. There
are 14 columns associated with each line. When I complete the entry for one
line, I would like it to automatically jump to the first column of the next
line (like a "Return" key on a typewriter). How can this be accomplished?

Thanks!
Karen

Can you set up a "Return" key - like a typewriter?
 

The following code will go to the next row as soon as a ceel in column 15 is
selected. If you are entering data manually, then after each entry you will
movw to the next cell to the right. So if you do the same thing on the 14 th
column the macro will select the first column on the next row. The macro goes
on the worksheet.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Column = 15 Then ActiveCell.Offset(1, -14).Select
End Sub

"KarenLZ" wrote:

I have over 3000 lines (rows) of data that I need to enter manually. There
are 14 columns associated with each line. When I complete the entry for one
line, I would like it to automatically jump to the first column of the next
line (like a "Return" key on a typewriter). How can this be accomplished?

Thanks!
Karen

Can you set up a "Return" key - like a typewriter?
 

hi
why not enter a couple of line then use the built in form.
on the menu bar....dataform
no code needed.

Regards
FSt1

"KarenLZ" wrote:

I have over 3000 lines (rows) of data that I need to enter manually. There
are 14 columns associated with each line. When I complete the entry for one
line, I would like it to automatically jump to the first column of the next
line (like a "Return" key on a typewriter). How can this be accomplished?

Thanks!
Karen

Can you set up a "Return" key - like a typewriter?
 

Never knew the Form existed! Awesome! Thanks!