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.

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.

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.

How do I skip cells after entering info?
 

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.

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.

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.