Using arrow keys instead of Tab/Enter

Is there a way to use the right arrow key so that when I hit enter it will drop down one row and back to the left like when you use tab and then enter?
I'm sifting through a stack of papers with my left hand and using the 10-key but as i enter data across a row it's very tedious to left arrow all the way back to the start.

Thank you

ref post#03

If cursor is not always in the same column , and cursor needs to always end up in ColumnA, one row down, then use something like this:

Please Login or Register  to view this content.

instead of:

Please Login or Register  to view this content.

Kevin, your second suggestion worked perfectly when I switched out the code, your first suggestion, however, kept bringing up a save as window. Doesn't matter too much because like I said the second part worked, just thought you may like some feedback on that code or maybe i'm doing something wrong. now i'd like to try to make the key to activate it something other than F12 but don't know what commands excel VBA will accept. could this be made as the page down key or pause/break key?

Try {Pgup} or {Pgdn} or {End} or instead of {F12}

There's a table of more options at the following link:

http://www.bettersolutions.com/vba/VRA233/YE846733531.htm

Oh! That's Beautiful!! Thank y'all. Saved me a bunch of useless keystrokes over the next couple of weeks.