Excel know how!

Re: Excel know how!

by David Fountain -
Number of replies: 0

I knocked together this VBA code which should do the job:

Sub loopCopyAB()
    Range("A1:B1").Select
    For i = 1 To 34 'change this value depending on how many sheets you require it will start from row 2 because of the next line
        ActiveCell.Offset(1, 0).Range("A1:B1").Select
        Selection.Copy
        Sheets.Add
        ActiveSheet.Paste
        Sheets("Sheet1").Select
    Next i
End Sub

Average of ratings: -