vidyashankara
New Member
- Joined
- Mar 24, 2014
- Messages
- 16
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 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...