Hello All,

I need to write a macro that will create a new sheet and name that sheet based on a list from another sheet.

Sheet1 range A1:A250 have product names, range B1:B250 have codes that match those product names. I will have a schematic (new sheet) for each product name and code in the workbook. When the user creates the new schematic for the next product, I'd like the sheet name to be "product name + product code".

Is there a way I can get the result I need?

Thank you for all the help!