Usually when I need to do this, it's because I don't want them to type in any
other cells except specific ones either... if that's the case, this will not
only advance thru those cells, but keep anyone from changing any other cell
as well. Select the cells for which you wish to allow data entry, chose
format cells and on the protection tab uncheck locked. Protect the sheet
(tools, protection) and leave only select unlocked cells checked. Hitting
enter will advance thru unlocked cells by column.

"Publius" wrote:

In Excel 2002 I want to insert a command in certain (not all) cells that once
data is entered therein and "enter" or a hot key is pressed advances the cell
selection to another specific (specified) cell within the worksheet. For
example: type "123" in C-1 and pressing "enter" moves the next cell
selection to E-12. Can anyone tell me how to do this?