When you type something in A25 and hit Enter you want the next active cell to
become E9.

Is that correct?

Or do you want the contents of A25 to move somewhere?

And where do the side by side lists come into the picture?

A little better description would help me decipher your question but maybe
others will be sharper and assist.


Gord Dibben MS Excel MVP

On Thu, 10 Aug 2006 13:41:02 -0700, Lisa wrote:

I need to make a cell once used automatically move a column over and up so I
can have lists side by side, how do I do that? for example A25 once filled
needs to make the selected cell be E9. HELP!