Most valuable professional
  • Hot Topics

Excel Help with Excel Macro

I am new to excel and I need to make a macro that reads data from Sheet1 and pastes it into sheet2 successively. This is how my sheet one looks.. A1 10 1249 A2 13 1232 A3 21 2312 . . . A1 402 12212 A2 432 23323 A3 442 23232 . . . I need Sheet 2 to look like this A1 10 1249 A2 13 1232 A3 21 2312 . . . A1 402 12212 A2 432 23323 A3 442 23232 . . . . . . . How do I write a macro for this? I recorded it using the recorder, and it works only for the first couple of values...

This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of March 24, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel