macro question
I want to type data in range("A1") and then click ENTER,
how to create a macro that when I click ENTER button, the
range will be changed to range("B1") to let me type data.
and then when I finished to type data in A1 & B1, I want
the range could be changed to next row to range("A2",
also will be changed to range("B2") after click ENTER.
how can I make a macro for this repeated procedure.
|