Need assitanceClosed

Question

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.

Excelguru · Answer

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.

Fery · Answer

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.

Need assitance

2 replies

Subscribe To Our Newsletter!