Using a list of names to create new sheets as a template

**GreggDavey** · 06-23-2010, 02:33 PM

Ladies & Gentlemen,

I have borrowed some code from David McRichie's site (see below). The code creates a new worksheet based upon a name (in my case a Stock ticker) entered into a column, It also ignores duplicates and places the stock symbol in cell 1A of the newly created sheet.

I can get it to run fine when I manually enter a symbol in the target column, but I need it to work via a copy / paste using a list of stock symbols. Again, it works fine if I copy just one, but it causes an error when I try and copy a list. Also, how can I get this code to copy a customized template(from within the same workbook) and not just add a sheet?

All the Best!
Gregg

Please Login or Register  to view this content.

**davesexcel** · 06-23-2010, 08:05 PM

If you are pasting into the target column more than 1 item you most likely will get an error, because your target count is greater than 1.
an additional error handler may be required

Please Login or Register  to view this content.

This will let you paste more then 1 item into the column. Then you will have to so something after to initialize the code again.

**shg** · 06-23-2010, 10:05 PM

Try this:

Please Login or Register  to view this content.

There's a bug in Excel that if you try to copy the same worksheet too many times, it falls over, and you have to save, close, and reopen the workbook. This code does not circumvent that, but there are easy ways to.