# Need assitance

Closed
Fery - May 7, 2009 at 11:20 PM
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
- May 14, 2009 at 02:46 AM
Hello,

I'm just beginning to learn excel macros.For this time, i do hope someone could help me to solve my problem.

I have one sheet, let say from "A1:H366" , the 'odd' rows contain values but the 'even' rows don't contain any values, for example:
A B C D E F G H
1 41 72 94 42 31 52 43 32
2
3 32 43 54 67 43 23 98 32
4
5 34 45 65 12 56 76 76 32
6
7 23 76 98 43 54 76 87 98
8
.
.
.
366

I want to cut the row "E1:H1" and then paste that row to "A2:D2". Afterthat, Cut the row "E3:H3" then paste it into row "A4:D4". Then, cut the row "E5:H5", paste it into row "A6:D6". and so on.
But the problem is i have 366 rows, how could excel macros perform this problem by just one executions, so i don't need to cut and paste manually.

I do hope someone can help to solve those problems.
I do appreciate every single advice.

Thanks a lot.

Fery.
Related:

## 2 replies

Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
May 8, 2009 at 02:05 AM
For this there is no need of a macro..

Insert a row at the top most row so that the data in the first row becomes in the second row
Now in cell J2 put the formula =A2+E1 and then drag it to fill three more cells to the right (till M2)
Then select cells J2 to M2 and then drag down you will get as desired.
I f you need any further assistance let me know.
Hai..

Thank you very much for your assistance brow. what a good answer for my question!..

I'm so embarrass right now, I didn't know that it doesn't need macro to solve the problem.
How poor i'm.

But, anyway, thank you for kind attention.It's nice of you.

I do hope i can ask more questions to you for next time.

Kind Regards,

Fery Marbun.
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
May 14, 2009 at 02:46 AM
Thanks
I do hope you can answer some questions of others some other time.