Hi,

I have two worksheets within the same workbook. On the first worksheet
"Sheet1" I have data on column D to S starting on row 7. The number of
row evolves over time. I am trying to create a loop to copy paste data
from "Sheet1" to "Sheet 2". However, on the destination "Sheet2", data
should be reported on only one column starting on cell B2. Each of the
data on the columns of "Sheet1" should go below each other on
"Sheet2".

As a example range D7:D40 in "Sheet1" should be copied on "Sheet2"
B2:B35. Then range E7:E40 in "Sheet1" should be copied on "Sheet2"
B36:B69, etc...

Thanks for your help.