Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I set up an auto return to the next column in excell?
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.) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I set up an auto return to the next column in excell?
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 -- 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 "radley38" wrote in message ... 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.) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I set up an auto return to the next column in excell?
Thanks! worked like a charm!
"Paul B" wrote: 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 -- 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 "radley38" wrote in message ... 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.) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I set up an auto return to the next column in excell?
Your welcome, thanks for the feedback
-- 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 "radley38" wrote in message ... Thanks! worked like a charm! "Paul B" wrote: 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 -- 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 "radley38" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
HOW DO I CREATE AN AUTO RETURN IN A COLUMN THAT IS OFF MY WORKSHEE | Excel Worksheet Functions | |||
Return the column name using if function. | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Lookup values in one column to return another | Excel Worksheet Functions |