• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

Excel 2007

Hello,
I'm trying to copy Column "D", FROM "D7" TO "D138" and paste them into Column "C" Starting "C150", Then Copy Column "E" startin g "E7" TO "E138" into Column "C" after the first paste ("C282") and so on.

Your help is appreciated.
Thanks,
sample.xlsx
0
W.E.B
Asked:
W.E.B
  • 3
1 Solution
 
wchhCommented:
Try macro code below
0
 
wchhCommented:

Sub fillCells()
    Dim copyRow As Integer
    Set Rng = ActiveSheet.Range("D7:EE7")
    copyRow = 150
    For i = 4 To 138
        ActiveSheet.Columns(i).Rows("7:138").Copy ActiveSheet.Range("C" & copyRow)
        copyRow = copyRow + 132
    Next i
End Sub

Open in new window

0
 
wchhCommented:
ignore previous code...
Sub fillCells()
    Dim copyRow As Integer
        copyRow = 150
    For i = 4 To 138
        ActiveSheet.Columns(i).Rows("7:138").Copy ActiveSheet.Range("C" & copyRow)
        copyRow = copyRow + 132
    Next i
End Sub

Open in new window

0
 
W.E.BAuthor Commented:
Aawsome, thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now