Have multiple blank worksheets to insert? You can insert multiple worksheets using Excel Macros!
Make sure your Excel has the Developer Tab enabled following this tutorial.
I explain how you can do this below step by step!
What does it do?
Insert multiple worksheets based on the user input of the number of sheets
Copy Source Code:
Sub InsertMultipleWorksheets() Dim numOfSheets As Integer 'Get the number of sheets from the user numOfSheets = InputBox("Enter number of sheets to insert", "Enter number of sheets") 'Add the additional sheets after the current active sheet Sheets.Add After:=ActiveSheet, Count:=numOfSheets End Sub
We only have one worksheet so far, let us work out our magic!
STEP 1: Go to Developer > Code > Visual Basic
STEP 2: Paste in your code and Select Save. Close the window afterwards.
STEP 3: Let us test it out!
Open the sheet containing the data. Go to Developer > Code > Macros
Make sure your macro is selected. Click Run.
Let us try out adding 5 worksheets. Click OK.
With just one click, you have inserted multiple worksheets!
How to Insert Multiple Worksheets Using Macros In Excel