Compare cells to named range and create new sheets using related named range

Hello all,
Please see attached example. Looking for some help to ignore sheets with the same names and create new sheets by comparing the value on the Maintenance sheet column D to the named range 'CustomerNumber' which is in column A. The code should take the corresponding value from the named range in column 'B' 'CustomerName' (add the underscore between names like Robert_Jones), compare it to the current sheets, and create any sheets that do not exist using the converted customer name as the name of the sheet before the Maintenance sheet. The code should also create a hyperlink on the Summary sheet for every customer sheet created and a link back to the Summary sheet in cell A1 of the created customer sheet. If there is a way to sort the customer sheets (or all sheets) alphabetically that would be great.

Thanks in advance!!
Andrew

Made a change to the Maintenance sheet to more accurately show the possible values and added some code to kinda do some of what I need.

Thanks stnkynts!! Both of those work perfectly for my example spreadsheet so I will keep this open a bit until I do production testing. There is a lot more involved but hopefully I have enough example code to do the rest. I think this was the hardest part. I was working on some code that was about 5 times longer than what you provided and I had not even started on the sheet sorting...

Andrew

I started testing with production examples and found that the code errors out when it reaches a field that does not have text separated by a space since the code is trying to insert a '_' between the words. So instead of creating a sheet for John Doe, the sheet needs to be created for John. I'm guessing there needs to be an If/Else added to check for a field with a space between the text and if not, the Else kicks in and the sheet is created with just the single word. Can you make the modification you think is will work the best?

Andrew

Tried the below modified code but

Please Login or Register  to view this content.

gives me a run-time error 1004 "Method 'Range' of object'_Global' failed"

Please Login or Register  to view this content.

Made a change and now the code runs all the way through but it is only creating the sheets for cells with a first and last name..not the cell with a single name.

Please Login or Register  to view this content.

Figured it out...

Please Login or Register  to view this content.

The code does a great job of adding the "_" between the t words in the cell but can it be modified to add "_" between multiple words? Some of the cells contain 5 or 6 words. I already have to tril the actual words down some to meet the 31 character limit but I still need "_" between the words.