View Single Post
 
Old 01-17-2020, 05:07 AM
jeffreybrown jeffreybrown is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

This should get you started

Code:
Sub Macro2_CopyPasteTRANSPOSE()
    Dim i As Long
    Dim x As Long: x = 6
    Dim LastRow As Long
    LastRow = Range("A" & Rows.Count).End(xlUp).Row
    Application.ScreenUpdating = False
    For i = 1 To LastRow Step 8
        Range("A" & i).Resize(6).Copy
        Range("B" & x).PasteSpecial xlPasteAll, , , Transpose:=True
        x = x + 3
    Next i
    Application.CutCopyMode = False
    Application.ScreenUpdating = True
End Sub
Reply With Quote