VBA - Creating a new named sheet with a sheet template

**Glensafro** · 01-09-2012, 05:04 AM

Example Sheet.xlsHello everyone,

I am relatively new to VBA and would like to know how to create a new sheet automatically. I have a workbook to be used to create quotations for customers with two sheets, the first is a form in which the customer selects various options relating to the product they would like and the second is a template for a printout page. Each different item that a customer buys needs a separate printout sheet in the format of the template sheet. What I would like is a way to use vba to create sheets for new items, for example when the user enters item number "2" on the form sheet a new sheet is created with the format of the printout template and the sheet name "Item 2", however if a sheet for that item number already exists the form outputs the data on to the existing sheet rather than creating a new one.

Thanks in advance for your help,

Glen

**arlu1201** · 01-09-2012, 05:20 AM

Welcome to the Forum.

It will be great if you attach a sample workbook and we can help you faster.

**NickyC** · 01-09-2012, 05:23 AM

As Arlette says, it would help to post a workbook so we can see what you are trying to do

This code could help to get you started. It assumes that the order details are in cell A1 of the sheet called “Sheet1”, while the workbook also includes a sheet called “template”. It will create a copy of the template sheet and give it a name identical to the contents of cell A1 unless a sheet with that name already exists.

Please Login or Register  to view this content.

**Glensafro** · 01-09-2012, 05:58 AM

Sorry for the delay in uploading this, busy morning here! I have mocked up a basic example of the printout form, final design is yet to be given to me to make so it is pretty basic, but the form information is more complete.