I have a workbook (attached below), includes three (3) worksheets, which will be used as a template, to be copied into a new workbook and/or worksheets. The number of new workbooks and/or worksheets will be based on a table for "stations" as attached in the "Start" Worksheet.
I intend to add two (2) buttons, which I need to automate as follows:
DESIRED FUNCTIONALITY
Button 1 click:
1- Create New Folder with the ORDER NAME cell
2- Under that folder, I need to create a new workbook for each station (i.e. workbook's name is "Station 1" for Station 1 and so on),
then copy all the 3 worksheets templates below (i.e. First_Sheet, Second_Sheet, and Third Sheet). Copy the values and the formatting NOT the formulas
3- Repeat step 2 for the rest of the stations until the last station.
4- Desired outcome: A new workbook for EACH station, each contains a copy of the 3 worksheets.
In this particular example, I expect 7 workbooks as an output for the seven stations, but there could be any number of stations up to 30
Button 2 click:
Exactly Same as Button 1, EXCEPT:
Create just ONE WORKBOOK includes ALL the worksheets for ALL the stations in the same workbook
Worksheets naming convention will likely be something like Station 1_First_Sheet, etc.
I appreciate any help; preferably a working, efficient, and fast running code, which will definitely make my weekend !!
Create New WorkBook_Worksheets.xlsx