Create new worksheets with names

I have a worksheet that has a list of stock names (tickers) and a template worksheet with a bunch of calculations. What I want to do is create a new template worksheet for each of the stock names that I have. So If I have 50 stock names I would create 50 new template sheets with the stock name as the name of the stock as the worksheet name.

Stocks (in worksheet("Stocks"))
aapl
msft
IBM

Would generate 3 new worksheets named "aapl", "msft", "IBM" each based on the template worksheet

try this macro:
It assumes the list of names is in column a since you did not specify.
It assumes a template sheet name of "mastertemplate" since you did not specify.
It looks at all of column A on the "stocks" sheet for names since you did not specify a cell range.

Please Login or Register  to view this content.

--------------------------
Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Minor tweak:

Please Login or Register  to view this content.