How do I skip cells after entering info?

  • Thread starter Thread starter B.McCall
  • Start date Start date
B

B.McCall

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.
 
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.
 
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.
 
For the specifics you cite. Right click sheet tab>view code>copy\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
 
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
 
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.
 
Back
Top