I know a lil bit excel, and i just started to learn VBA, need some help on creating this report.

In a

*worksheet "Hist"*i have a 36 block of data located in a single row, each block use 12 column of data

block 1 = F4:Q4, (3 blanc column) then Block 2 = U4:AF4, then (3 blanc column) and Block 3.... and so on

what i need to achieve is :

extract block 1 (12 data column) and copy to

*worksheet "Report"*but "

*non adjacent row*", starting on

Code:

`$B4:$Q4`

*worksheet "Report"*but "

*non adjacent row*", starting on

Code:

`$U5:$AF5`

*worksheet "Report"*but "

*non adjacent row*", starting on

Code:

`$AJ6:$AU6`

*worksheet "Report"*but "

*non adjacent row*", starting on

Code:

`$AY7:$BJ7`

thank you in advance, Any help is appreciated !

Andyjr