Need assitance

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
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

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
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.
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Thanks
I do hope you can answer some questions of others some other time.