data Transpose in VBA loop, choose the part I want to import!

1 Attachment(s)

Hello I am working for my school project that I need to follow,

Step 1. Copy from original rep this year row (26:27)
Paste Transpose to data sheet > > Column range E9:F39
Paste Transpose to End report sheet > > Column range B11:C41

Step 2: Copy from original rep this year row (36:37)
Paste Transpose to data sheet > > Column range P9:O39
Paste Transpose to End report sheet > > Column range N11:O41

Step 3: Copy from original rep this year row (46:47)
Paste Transpose to data sheet > > Column range AA9:AB39
Paste Transpose to End report sheet > > Column range Z11:AA41

The question part is how to match the data into certain column since I don't need all of the data from the original report. Please help, thank you so so so much!
I hope this explains. Thanks.

Attachment Attachment 690

You want to copy and transpose data or need to match data. :confused:
May be example with the output would be good.

You could write

Code:

Worksheets("Data").Range("E9:F39").Value = Application.Transpose(Worksheets("Original Rep This Year").Range("B26:AF27").Value)

By the way, if it's a school project, shouldn't you be doing this yourself?