M
Mike
Manually, copy one, then copy 2, then copy 4 is the only
way to go, but a macro may make life easier. Then there's
the problem of naming the sheets. Do you want them simply
numbered? For this, I took an empty workbook, named a
sheet 1, then deleted the other two default sheets. This
will then create 99 copies of the sheet and number them 2
to 100.
Sub CopySheets()
For A = 2 To 100
Sheets("1").Copy After:=Sheets(A - 1)
Sheets("1 (2)").Name = A
Next
End Sub
way to go, but a macro may make life easier. Then there's
the problem of naming the sheets. Do you want them simply
numbered? For this, I took an empty workbook, named a
sheet 1, then deleted the other two default sheets. This
will then create 99 copies of the sheet and number them 2
to 100.
Sub CopySheets()
For A = 2 To 100
Sheets("1").Copy After:=Sheets(A - 1)
Sheets("1 (2)").Name = A
Next
End Sub