Thread: Macro question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wooo wooo is offline
external usenet poster
 
Posts: 3
Default Macro question

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.