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.
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.
