Hi all,

I have to input data in excel. Detail are as follows,

First, I have to input data in Range "A1", and then move
to Range"B1" to input data and last move to Range "C1" to
input another data. When complete these steps, I will
move to next row and input other data in Range "A2", "B2"
and "C2" again, and then go to next row and do the
repeated steps again.

Now, how can I use macro for me to do these steps. That
means when I input data in Range "A1", Click "enter"
button, the range will move to Range"B1" to let me input
other data, and then I press "enter" button again, it
will move to Range"C1" to let me input other data.........

I have try to use macro to record these steps, but it is
not work, because it just record what data input and I am
not able to input any data when the macro is running.

Have you tried selecting tools, options, edit, move cursor
to right?

John
-----Original Message-----
Hi all,

I have to input data in excel. Detail are as follows,

First, I have to input data in Range "A1", and then move
to Range"B1" to input data and last move to Range "C1" to
input another data. When complete these steps, I will
move to next row and input other data in Range "A2", "B2"
and "C2" again, and then go to next row and do the
repeated steps again.

Now, how can I use macro for me to do these steps. That
means when I input data in Range "A1", Click "enter"
button, the range will move to Range"B1" to let me input
other data, and then I press "enter" button again, it
will move to Range"C1" to let me input other data.........

I have try to use macro to record these steps, but it is
not work, because it just record what data input and I am
not able to input any data when the macro is running.
.