Try this one
![]()
Sub columnstocol() Dim i As Long, ms As Worksheet, LR& Application.ScreenUpdating = 0 Set ms = Sheets("FRL Summary Sheet") NR = 2 With Sheets("FRL Input") LR = .Cells.Find("*", , , , xlByRows, xlPrevious).Row For i = 3 To LR Step 75 .Cells(2, 3).Resize(, 3).Copy ms.Cells(3, NR) .Cells(i, 3).Resize(75, 3).Copy ms.Cells(4, NR).Resize(75, 3) NR = NR + 4 Next Application.CutCopyMode = 0 Application.ScreenUpdating = True End With ms.Columns.AutoFit ms.Activate Set ms = Nothing End Sub
Bookmarks