Lisa,

There is an inconsistency in what you are saying.

I need to make a cell once used automatically move a column over and up

does not agree with:
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!

Do you mean one column or four columns over?

If one column then highlight the area that you want the side by side lists
in - say A9:E25 then, having first made sure that the "Move after selection"
in Tools Options Edit is set to Down, simply enter the data and press
Enter. When the cursor comes to A25 it will automatically jump to B9 for
the next list.

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Lisa" wrote in message
...
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!