How to make multiple copies of Excel sheet in automatic mode

In this guide will be shown how to make multiple copies of Excel sheet in automatic mode. Two or three sheets could be copied manually very fast, but what about 15 or 50 sheets? Our AutoSheetsCopy macros will make it easily and very fast. It works with any Excel books. Maximum sheets to be added in your book - 1024.

1. Please download AutoSheetsCopy ZIP archive and unzip it to HDD.

2. Import AutoSheetsCopyForm.frm Form file into your Excel book (Read How-To)

3. Import AutoSheetsCopyModule.bas Module file into your Excel book (Read How-To)

4. Please return to sheet in your Excel you need to copy, press "ALT+F8", select "AutoSheetsCopy" in "Macro" window and press "Run" button. Initial User Form with "Auto Sheets Copy" caption will appear.

5. Select (up to 1024) number of copies, then press "Copy" button

6. In a few moments the sheet you have selected will be copied. By default, new sheets will be named as "Sheet1_2", "Sheet1_3", etc. Maximum length of Excel sheet's name is 31.