New sheet name extracted from various cells, sorting sheets, saving new workbook

Dear Excel experts,

I have designed a form to be filled out by various persons. At the end of the form, I have inserted a button that will:

1) Copy the Master sheet
2) Prompt the user to give a name to the new sheet, which will then create a copy of the entire Master sheet
3) Delete all the filled in fields on the Master sheet

So far, the code is the following:

Please Login or Register  to view this content.

In order to diminish mistakes from users, I would like to have the new sheet's name defined automatically, based on 3 cell values in the Master sheet. These cells would be C16, C14 and C23. Ideally, each value would be separated by - (e.g. "Corporate - 36 - BMW").

My second issue would then be to sort all sheets alphabetically, keeping in mind that I do not know in advance how many sheets will be generated.

Finally, I would like to group the sheets according to part of their name (the part derived from C16) and then save them as a new excel document on the Desktop, with a predefined name. Again, I do not know in advance how many sheets will be generated. I have a partial code, which is the following:

Please Login or Register  to view this content.

Thank you so much for your help!

Best regards,

Luccin

somewhere in the macro can you not add (within the first few lines) try to add this statement



the sample code statement will be somewhat like these

Please Login or Register  to view this content.

can you incorporate this in your macro.

regarding the final stages of the macro instead of repeating statements can you not create a loop. I have not studied your macro completely.

Dear venkat1926,

Thank you for your help. This code partially answers my questions. In any case, it is much appreciated!

Regards,

Luccin