Hello,
I would really appreciate some help as I am not that well versed in VBA. What I'm trying to accomplish is the following:
a) Row 1, Col B thru M have months listed (Jan - Dec).
b) Col A starting from Row 2 goes down in this order: Q1,Q2, Q3, Q4, Q1, Q2, Q3, Q4....keeps repeating.
c) Each Q1-Q4 for the first 4 rows have the same #s (i.e., 200, 200, 200, 200). The second set of Q1-Q4 has a different set of #s (i.e., 500, 500, 500, 500). And this goes on down to hundreds of rows.
SAMPLE
1 A Jan Feb Mar Apr May...
2 Q1 200 200 200 200
3 Q2 200 200 200 200
4 Q3 200 200 200 200
5 Q4 200 200 200 200
6 Q1 500 500 500 500
7 Q2 500 500 500 500
8 Q3 500 500 500 500
9 Q4 500 500 500 500
What i need to do is:
1. Take Row2 Col B,C,D and cut/paste to Row1 Col E,F,G.
2. Do the same for Rows 3 & 4, but paste into Col H,I,J & K,L,M respectively.
3. Delete Rows 2-4.
4. Repeat Steps 1-3, however, this time the cut and paste will start from Row 4.
I need to do this until all the #'s have been cut/paste from Jan - Dec.
Any help would be greatly appreciated and thank you in advance.
Bookmarks