Dynamically create sheets with similar names and copy cells on row based on matched cus#

Hello all. At the title indicates, I need help with 2 parts of my project. The first is that I have some customers that have similar names and the current code cannot validate and create additional sheets after the first one has been created. For example: Richard_John_Worthington and Richard_John_Worthington1. The code will create the first one correctly and populate it with the correct data but when the second one is processed in the code, it throws a Type Mismatch while checking to see if the name already exists.


My second problem is I need to match the customer number on ZZ_Maintenance to the one currently being processed on 1_ImportedData, then cells in column D to F on ZZ_Maintenance for the matched customer number need to be pasted on the new customer sheet in D3. The examples I have seen copy the entire row but I could not find any that would do a range of cells in the row. I am using conditional formatting in customer rows D2 to F2 to compare to the values in D2 to F3 but each customer may have their own values for the items so I can't do this manually for each new customer. I think I did the conditional formatting correctly to check the values for the entire row, but if somebody could verify that would be great!

Thanks,
Andrew

A lot of trial and error produced

Please Login or Register  to view this content.

that looks like it will work to copy the cells from the matched customer number.

I am getting a "excel vba run time error 13 type mismatch" at the first line of the below code block after it had run completely through one time. It looks like I need to check for an empty value or something and if found, end the "If" but I have not figured it out yet. Anyone know how to do this in this instance?

Please Login or Register  to view this content.