have excel go to defined cells when pressing ENTER

[Guest]

How can I have excel go to defined cells when pressing ENTER after entering
info in a cell
(from cell Aa1 input info press Enter and go to H16 to input info in that
cell press ENTER go to A45 and so on)

 

[excel-ant]

The only think I can think of is for you to protect the sheet and
unlock the cells you want to navigate around. (Only these will be
selectable)

Ant

 

[Guest]

Thank You
That could work
I was looking for a way to jump to cells not in any order just defined
Start @ A3 then jump to A15 back to B6 maybe to H7 to A4 to B17 to A5 so on

 

[Guest]

Thank you Gord Dibben
that did it


You can use a named range to "jump" through in any order you design.

Select SECOND cell then CTRL + click on each succeeding cell in sequence,
ending
up with the cell you want to start at.

Insert>Name Define........give your range a name and OK.

In namebox select the name and the cells will be highlighted in the order you
want.

Just type and hit ENTER key to go to next cell.

Note: there are limitations on the number of cells in a range.

See Bob Phillips' site for more help on this.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is a VBA method if you choose. Post back for that.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Good to hear.

Thanks for the feedback.

Thank you Gord Dibben
that did it


You can use a named range to "jump" through in any order you design.

Select SECOND cell then CTRL + click on each succeeding cell in sequence,
ending
up with the cell you want to start at.

Insert>Name Define........give your range a name and OK.

In namebox select the name and the cells will be highlighted in the order you
want.

Just type and hit ENTER key to go to next cell.

Note: there are limitations on the number of cells in a range.

See Bob Phillips' site for more help on this.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is a VBA method if you choose. Post back for that.


Gord Dibben MS Excel MVP