The type of macro that you are referring to is called an event macro. In
your case the event would be any entry made in any cell. This would trigger
the macro to run.
The code that is written in the macro would then check to see if the
Target cell (the cell that changed) is in this range or in that range or in
the other range, whatever. The code would then move the cursor like you
want it moved for the particular range. If this sounds like what you want,
post back and provide some detail about the layout of your data and what you
want (cursor movement direction) for each range you designate. The ranges
don't have to be locked in stone, but Excel will need to have some means of
determining the ranges and what ranges go with what cursor movement. HTH
Otto
"WLMPilot" wrote in message
...
I have an Excel workbook utilizing two sheets: Items & Order.

Items sheet contains Item#, Item Name, Stock Levels (Fully Protected)
Order sheet is a form with protected & unprotected cells. The first two
sections that the user fills out has the cursor moving down after each
entry,
which I want.

However, I need the cursor to move left to right in the last section
without
having to make the universal change for Excel via Tools Options Edit.

I was told via a previous question to use a macro. Being unable to locate
the original question, I need someone to provide me with the code that
does
this, being aware that the direction needs to change at a certain point
within the sheet.

I also need help with something I just thought of. The second section of
the Order sheet allows the user to order specific, rarely used items. I
am
thinking of putting a prompt to ask if there is anything to be ordered
within
this section. If "NO", then I need to have a macro catch this and bypass
the
second section and proceed to the third section.

Thanks in advance!!
Les