Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry Cells
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry Cells
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry Cells
Scott or Kindlysinful -
If you select the range first, e.g., A1:F5 for five rows of data, then after you type in a cell, you can use the Tab key (instead of the Return key) to move to the next cell in the selected range. For the A1:F5 example, when you are in cell F1 and press the Tab key, the active cell becomes A2. For Mac-specific questions (unlike this one), consider the very active microsoft.public.mac.office.excel newsgroup. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Kindlysinful" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
limiting data entry cells | Excel Discussion (Misc queries) | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
Validate MsgBox Entry to Data in Cells | Excel Discussion (Misc queries) | |||
data entry from two cells across worksheets | Excel Discussion (Misc queries) |