copying and pasting data from sheet 1 to sheet 2 in VBA

[jmkelly1988]

Alright I've figured out a lot of ways to copy and paste data, but none work how I want them to.

If I have set cells and ranges from sheet 1:

B3,B10,B17,B24,B31,B38,B45(Cells)
C2:H7,C9:H14,C16:H21:C23:H28
C30:H35,C37:H42,C44:H49(Ranges)

And want to copy to sheet2 in the following fashion:

B3 to A3, B10 to E3, B17 to I3, B24 to M3, B31 to Q3, B38 to U3, B45 to Y3

C2:H7 to A4:D9, C9:H14 to E4:H9, C16:21 to I4:L9, C23:H28 to M4:P9, C30:H35 to Q4:T9, C37:H35 to U4:X9, C44;H49 to Y4:AB9

That part is easy...the problem I'm running into is after this pastes (which is by clicking a command button). I would like it to then to increment by 8 where it pastes next time.

This is being pasted to a calendar so there are dates in increments of 8(start in row 2 and then in row 10 the 18 and so on).

If anyone can help me I would absolutely love them forever!!!

 

[jmkelly1988]

Is there way to up vote you on here????? Is there a way to put a countif into the fmAry for the single cell ranges?