Thanks for the input. Here is more detail. Let's say as an example I am
using column 1, rows A-Z and Column 2 rows A-Z

I want to start in A1 enter data then have it move to A2, enter data, then
b1, etc.

But in some of the fields I have drop down options.

I am somewhat new to macros - in the past I have used Lotus and in those
macros you could build the macro to allow input i.e. "??" would represent
data to be entered. If you are interested in assisting with this, please
email me at and I would be happy to forward a sample
document.

"Nicole" wrote:

I am working on a spreadsheet and I know how to turn on and off the macro.
However, I want to enter information (once the macro is turned on) and have
the macro then move me to the next cell once information is entered.

I have used keystokes, but the keystrokes are recorded.


Thanks.