Hello Md,
I don't totally follow what you would like to do but here's a starting point:-
This code will create new sheets from a template sheet based on a value selected from a drop down in cell A1.
It is a Worksheet_Change event code and needs to be placed in the Template sheet module. To implement this code:-
- Right click on the Template sheet tab.
- Select "View Code" from the menu that appears.
- In the big white code field that then appears, paste the above code.
It is an event code so as soon as you make a selection from the drop down in A1, a new sheet will be immediately created from the Template and named with the selected value.
Below, I've attached a mock-up of how this works and should give you an idea of how it could work for you.
I hope that this helps.
Cheerio,
vcoolio.
Bookmarks