How can I set up an auto return to the next column in excell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

radley38 - 09 Nov 2006 23:37 GMT

I am entering data in sets of three cells in each column on a spreadsheet.
Can I set up an auto return so that when I hit "enter" on the third cell, it
will automatically go to the first cell in the next column? (Bascially set up
a pattern such as - <enter>=go down one cell, <enter>=go down one cell,
<enter>=go up two cells and right one cell.)

Reply to this Message

Paul B - 10 Nov 2006 03:14 GMT

radley38, you could do it with some code, like this

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Row = 4 Then Target.Offset(-3, 1).Select
End Sub

To put in this macro right click on the worksheet tab and view code, in the
window that opens paste this code, press Alt and Q to close this window and
go back to your workbook. If you are using excel 2000 or newer you may have
to change the macro security settings to get the macro to run. To change the
security settings go to tools, macro, security, security level and set it to
medium

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> I am entering data in sets of three cells in each column on a spreadsheet.
> Can I set up an auto return so that when I hit "enter" on the third cell, it
> will automatically go to the first cell in the next column? (Bascially set up
> a pattern such as - <enter>=go down one cell, <enter>=go down one cell,
> <enter>=go up two cells and right one cell.)

Reply to this Message

radley38 - 10 Nov 2006 18:02 GMT

Thanks! worked like a charm!

> radley38, you could do it with some code, like this
>
[quoted text clipped - 16 lines]
> > a pattern such as - <enter>=go down one cell, <enter>=go down one cell,
> > <enter>=go up two cells and right one cell.)

Reply to this Message

Paul B - 10 Nov 2006 18:35 GMT

Your welcome, thanks for the feedback

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> Thanks! worked like a charm!
>
[quoted text clipped - 18 lines]
> > > a pattern such as - <enter>=go down one cell, <enter>=go down one cell,
> > > <enter>=go up two cells and right one cell.)

Reply to this Message