VBA InputBox Issue

I reiterate my comment at the bottom of my last post re "System Analysis" prior to commencing the programming. The programmer writes the code as per the specifications provided and that is what I have attempted to achieve and I previously used the Categories as per the examples given. Please don't get upset about me saying this but for your future projects I want you to understand how important it is to get the specifications correct before commencing the programming.

Anyway the categories were not too difficult to change. I simply added another column to the table on Main Menu sheet and updated the category header in the code based on the first and last column of the table. Your Category with numbers must remain as is on the Template Worksheet in the Macro workbook. You can still add more categories to the table but you will need to update the template category worksheet with the extra categories. The loop for the categories is not limited to 4 because the code will process as many as there are in the table on the Main Menu worksheet.

I did not previously realize that you wanted to run the code separately for each scenario and I combined both . However Scenario 1 and Scenario 2 are now controlled with a CheckBox on the Progress Userform. If Categories are required then check the box before clicking the "Start" button. If the box is not checked then the categories sub is not called and also the categories worksheet is not copied to the Output workbook. I have changed the code at around lines 139 to 158 and used a separate Case statement for each template worksheet name to be copied instead of in one Case statement with comma separated list of worksheets. (Are you aware that you can see the cursor position line number on the toolbar in the VBA editor?)

Updated macro workbook and source data file at the following link.   New Version 7

In answer to your comment as follows a few days ago. 

While processing column W in wsSource. code introduces line breaks. but in the categories I use Wrap? I feel there is no need to introduce line breaks, only remove the leading part of column W.

It is not practical to simply use Wrap Text without the line feed. There is no way of controlling where the line will break. Generally it will be at a space or hyphen but depending on the length of the string, it might break in the middle of a word or if the column is too wide, it includes multiple words that were meant to be on separate lines.

Column AutoFit does not increment the width of a column when Wrap Test is on because the text wraps to fit the existing column width so therefore Excel thinks it does not require widening.

However, if the column is too wide wide it will decrement the width to the longest existing string. By using the Line Feeds the longest existing string across the column is controlled by length of text between the line feeds. Therefore one would think that AutoFit should work but unfortunately it will not increment the width. It is necessary to increment the width wider than ever likely to be required and then use AutoFit.

I did not previously realize that you wanted to run the code separately for each scenario and I combined both

Scenario 2 macro has to run for both the sheets as you did. We had another macro Scenario 1 which was my initial request which only deals with the Output sheet because the wsSource does not have all the data that is required for categories sheet once I pull all that into wsSource only then I can populate both Output and categories sheets in one go. So wsSource is different for both the macros. Therefore they both are different.

Scenario 1 Macro working good on actual data set.

Scenario 2 I will test on the actual data set. 

Scenario 2 looks good.

For the Scenario 2 I want to make a variant that variant version will be used in particular cases. I attempted to do it but I am facing some difficulty in framing the code because it requires loop within a loop within a loop. May be there is a better way to do it.

What I am trying to do is after I paste a set of Unique numbers with out duplicates in the unique sheet.

The Unique numbers can also be taken from the excel by uploading the file.

See e.g. I want to loop through the unique numbers based on the Column B. It would loop through all AMN1 unique numbers and look in wsSource and loop though the rows and populate the rows in the template and save. Loop continues for column B until AMN4. 

AMN1 to AMN4 can be named in any format we want. Those characters are only to separate the set of unique numbers that goes into the template.   

The new addition in the template is it would also capture the unique numbers as well this time in the template. So there will be a new column before VC number in the output sheet and before Half Number in categories sheet. 

I will share the file for better understanding.

e.g

Column A               Column B

Unique Number1   AMN1

Unique Number2   AMN1

Unique Number3   AMN1

Unique Number4   AMN2

Unique Number5   AMN2

Unique Number6   AMN2

Unique Number7   AMN3

Unique Number8   AMN4

Unique Number9   AMN4

I will share the file for better understanding

I don't understand your description and there is no file to download and try to ascertain what you want.

I will share the file with you shortly. Creating the data set for Scenario 2 is a task. I am on it right now. May be that should also be done by macro using Find, Offset and Like functions. But that would make the macro run for a long time. Need to think about it.