Vba to Create copy of worksheet and range of cells to used to calculate inputs.

I am trying to make a calculation sheet that will with the press of a button and creation of a drop down box then create a several worksheets with calculations

1. is it even possible to use a VBA to create a worksheet with data in it?
2. I am attaching a sample of the sheets I want to create with the VBA and want them to duplicate based on the drop down box. I.e if the drop down box says 2 it would repeat those sheets so I would have two sets of sheets.


I am new to VBA and macros, I am trying to learn and searched this everywhere. I would prefer to do it myself instead of copying and pasting so directing me to somewhere would be more than enough. Calctest.xlsx

Create a template sheet

This code will unhide a Template sheet, copy & rename it, then hide the template

Please Login or Register  to view this content.

Thanks for the rep, if this is solved please mark the thread as solved


How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save