Do you want a programming solution or other?

You can protect the sheet with the cells to move to unlocked and disallow
selection of locked cells.

You can define a named range and follow the sequence of the cells in the named
range.

See Bob Phillips' site for named range method.

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

You can use Case Select code to move from one cell to another as you press enter
key.


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 19:11:00 -0800, Programing problem
wrote:

after enering data how can I press enter to move to a specific cell?