Cell movement after entry

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

DO you know if there is a method to force the movement to
the next cells after data entry. For example to move from
A1 to B1 then after B1 to move to A2 etc. Basically to
build a date entry type form.
 
Hi Jack,

Try using a named range perhaps.

Select the second cell in range of cells and hold down the Ctrl key. Now
click on each cell of your range in the order you want to progress through
them, and finally select the very first. Now click in the name box and
apply some pertinent name to the range, and then click anywhere on the
sheet. To recall your range, click the arrow next to the name box and the
click on the named range. All the cells in the named range will be selected
and the first cell will be the active cell. Enter your data and hit either
Tab or Enter. You will cruise through the cells in the order you selected
them.

If you have quite a few cells in the named range you will probably have to
use multiple named ranges. Seems after about 25 or 30 it won't hold them
all, can't remember for sure.

HTH
Regards,
Howard
 
Back
Top