Create Worksheets Based on Cell Values

[modytrane]

I am attaching a sample worksheet that shows what user input would look like. Based on the names and quantities defined by the user, would it be possible to create worksheets. These worksheets would be copies of preformatted and previously created master sheets. The master sheets could be stored within the workbook [Hidden] or in another workbook available on the network.

I had looked at this before with userform, but it doesn't need to be anything fancy.

Can someone help me with a Macro that could read the cell values for names and quantities and create copies of appropriate worksheets?

Thanks a lot for any help or suggestions.
modytrane.

[royUK]

It's not difficult to do this, how are you going to name the sheets/ It's not clear to me from your example what you need to create.

[modytrane]

Thanks for replying.
Basically, I'll have Nine Types of Sheets. First six will be named as Type 1 thru Type 6. Other Three will be Sub Type A thru Sub Type C.

The user will have an area where they will make their selections. The selections will be made via dropdown menus.

So for example if they are selecting in Cells B4:B10.
They could select Type 1, Type 3, Type 4, Type 2, Type 5, Type 2.
Next column [C4:C10] will have quantities.
Column D4:D10 will have dropdown menus with Sub Type and E4:E10 will have qauntities for them.

I have attached the example again with comments in it.

As for the naming, I would like to name them by their types. The number in () indicates 1st, 2nd etc. Some of the Main Type [1,2,3 ..] may have Sub Types assigned to them. In that case, firstwe create Main types and then Sub Types.


Hope this makes it a bit clear. Please see the example, it should help.

Thanks a lot.
modytrane.