| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I skip cells after entering info?
I have a work book I use often in Excel 2003 and would like to know if there
is a way to enter info on say cell D15 then hit the enter key and the cursor would automatically skip to say cell D25, then to cell D35 and so on. I'm not an Excel guru but I can manage, just can't figure this one out if it is even possible. Any advise would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I skip cells after entering info?
More info needed as to layout, etc.You could use a worksheet_change event in
the sheet code or lock cells and use tab key. -- Don Guillett Microsoft MVP Excel SalesAid Software "B.McCall" wrote in message ... I have a work book I use often in Excel 2003 and would like to know if there is a way to enter info on say cell D15 then hit the enter key and the cursor would automatically skip to say cell D25, then to cell D35 and so on. I'm not an Excel guru but I can manage, just can't figure this one out if it is even possible. Any advise would be appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I skip cells after entering info?
The work book is used for pricing different levels of a product. I created
different blocks for different levels. When I enter a cost in D15 and the sell price is indicated in in the last cell of that level. Then I have to scroll to cell D25 for the next level. I want to just enter the cost in cell D15 of level 1 and when I hit enter the cursor would automatically go to cell D25 which is level 2. Does that help. "Don Guillett" wrote: More info needed as to layout, etc.You could use a worksheet_change event in the sheet code or lock cells and use tab key. -- Don Guillett Microsoft MVP Excel SalesAid Software "B.McCall" wrote in message ... I have a work book I use often in Excel 2003 and would like to know if there is a way to enter info on say cell D15 then hit the enter key and the cursor would automatically skip to say cell D25, then to cell D35 and so on. I'm not an Excel guru but I can manage, just can't figure this one out if it is even possible. Any advise would be appreciated. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I skip cells after entering info?
While in cell D15, define a short name, like "a", to be
=D25 After you enter in D15 (enter via ctrl/enter so the cursor stays in D15), you can press F5, type "a" (no quotes) and enter, and you'll be in D25. From D25 if you F5/a, you'll be in D35, etc. Just a thought! HTH "B.McCall" wrote: The work book is used for pricing different levels of a product. I created different blocks for different levels. When I enter a cost in D15 and the sell price is indicated in in the last cell of that level. Then I have to scroll to cell D25 for the next level. I want to just enter the cost in cell D15 of level 1 and when I hit enter the cursor would automatically go to cell D25 which is level 2. Does that help. "Don Guillett" wrote: More info needed as to layout, etc.You could use a worksheet_change event in the sheet code or lock cells and use tab key. -- Don Guillett Microsoft MVP Excel SalesAid Software "B.McCall" wrote in message ... I have a work book I use often in Excel 2003 and would like to know if there is a way to enter info on say cell D15 then hit the enter key and the cursor would automatically skip to say cell D25, then to cell D35 and so on. I'm not an Excel guru but I can manage, just can't figure this one out if it is even possible. Any advise would be appreciated. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I skip cells after entering info?
Thats the ticket. Thanks for your help, I would have never been able to
figure that one out. Is there a good book or perhaps a class I can look into, I use excel alot for work. "Don Guillett" wrote: For the specifics you cite. Right click sheet tabview codecopy\paste this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$D$15" Then Range("d25").Select If Target.Address = "$D$25" Then Range("d35").Select If Target.Address = "$D$35" Then Range("d45").Select End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "B.McCall" wrote in message ... The work book is used for pricing different levels of a product. I created different blocks for different levels. When I enter a cost in D15 and the sell price is indicated in in the last cell of that level. Then I have to scroll to cell D25 for the next level. I want to just enter the cost in cell D15 of level 1 and when I hit enter the cursor would automatically go to cell D25 which is level 2. Does that help. "Don Guillett" wrote: More info needed as to layout, etc.You could use a worksheet_change event in the sheet code or lock cells and use tab key. -- Don Guillett Microsoft MVP Excel SalesAid Software "B.McCall" wrote in message ... I have a work book I use often in Excel 2003 and would like to know if there is a way to enter info on say cell D15 then hit the enter key and the cursor would automatically skip to say cell D25, then to cell D35 and so on. I'm not an Excel guru but I can manage, just can't figure this one out if it is even possible. Any advise would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering several pieces of info by typing just 1 defined name | Excel Worksheet Functions | |||
| How to protect cell with formula from being entering info | Excel Worksheet Functions | |||
| how to skip to next cell to lookup info until found | Excel Worksheet Functions | |||
| entering info into different worksheets | New Users to Excel | |||
| getting info into a new tab and changes when entering in other tab | Excel Worksheet Functions | |||
Linear Mode
