Macro to copy 6 rows to 6 different new sheets

[Jack-P-Winner]

How would to write a Macro that will copy 6 rows from sheet 1 and paste the data on a new sheet? Lets say I have data in in the following rows:

A3:Z3
A4:Z4
A5:Z5
A6:Z6
A7:Z7
A8:Z8

I want to copy this data to a new sheet except place it like this

A3:Z3 to sheet 2
A4:Z4 to A50:Z50 to sheet 3
A5:Z5 to A100:Z100 to sheet 4
A6:Z6 to A150:Z150 to sheet 5
A7:Z7 to A200:Z200 to sheet 6
A8:Z8 to A250:Z250 to sheet 7

then I want to do the same thing with more rows like

sheet1
A12:Z12
A13:Z13
A14:Z14
A15:Z15
A16:Z16
A17:Z17

I want to copy this data to a new sheet except place it like this

A3:Z3 to sheet 2
A4:Z4 to sheet 3
A5:Z5 to sheet 4
A6:Z6 to sheet 5
A7:Z7 to sheet 6
A8:Z8 to sheet 7

I have more but perhaps someone can get me started and I can try to complete it

Thanks for your help

 

[Nebu]

Hi:

Find the attached. I have coded it for first set of data.

Thanks

 

[Marc L]

Hi !​

I want to copy this data to a new sheet except place it like this

A4:Z4 to A50:Z50 to sheet 3

Beginner easy way is to use Copy method (see VBA inner help)
as you can start your own code using Macro recorder …

Sheet1.[A4:Z4].Copy Sheet3.[A50]
​

 

[Jack-P-Winner]

Thanks you all. This gives me something to work with and so good start