Hi,

I am preparing a form for the sales team. I want them to type the
information only in certain cell and when they key "Enter" it should go the
the specified cell. This function is workable with "Tab" key (Using Protect
Sheet Function) but i want it to work with the "tab" as well as "enter" key .

For Example: If the data is entered in cell A5 and if the user hits "Enter"
the cursor should go in Cell A7 after that when it is hit Enter" the cursor
should go to cell D7.

Thanks and Regards

Mat wrote:
Hi,

I am preparing a form for the sales team. I want them to type the
information only in certain cell and when they key "Enter" it should go the
the specified cell. This function is workable with "Tab" key (Using Protect
Sheet Function) but i want it to work with the "tab" as well as "enter" key .

For Example: If the data is entered in cell A5 and if the user hits "Enter"
the cursor should go in Cell A7 after that when it is hit Enter" the cursor
should go to cell D7.

Thanks and Regards

Maybe you could make a "user form" that enters the info into the correct
cells for you using VBA I find that is the easiest way to get data onto
a sheet in the same format each time.