W
WLMPilot
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
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