If worksheet name doesn't exist from list then create using template

Hi everyone,

I have a list of cell values from worksheets("Sum").Range("J17") to end(xltoleft)

There are worksheets in my workbook that are named using the values in the range above & "ABC"

What I'm trying to do is have a macro which will loop through range listed above, and if it does not fine a corresponding worksheet in the workbook with one of those values & "ABC" a new worksheet will be created using a worksheet called ABC Template, the sheet will be renamed using the extra value in range & "ABC", and the extra value will be place in cell B10 in the new worksheet.

Example:

J17 = 123, J18 = 234, J19 = 354

In the workbook, there are two worksheets

123ABC, 234ABC, but no 345ABC

The macro will see this missing worksheet, create a new one using ABC Template, rename the worksheet as 345ABC, and place the value 345 in cell B10 of the new worksheet.

Any ideas?

Thanks!!

This is the code I have so far:

Please Login or Register  to view this content.

So right now MyCell is the cell value & ABC, i.e. 123ABC. However, when I run this code the ABC Template only copies without changing the name to say 345ABC and it seems to want to create an ABC Template copy for every cell in the MyRange. I'm guessing its because its not renaming the sheet properly.

Any ideas?

Thanks!!

Hi sintek,

Thanks very much for your code. It sure seems to work my faster than the one I put together. However, when I run the code it only creates a new worksheet for the last cell in the range("J17").end(xltoleft) range. The code needs to create worksheets for any cells in that range which don't already have a worksheet in the workbook.

Any ideas?

Thanks!

Here's what I have so far. This code does what its supposed to do. However, it takes a bit of time to run through because it creates copies of the SUM worksheets and then deletes the copies while retaining the new SUM worksheets. It would be a big help if it would just create the worksheets based on a comparison between the list and the existing worksheets rather than running through them all.

Please Login or Register  to view this content.

That's it! Perfect! Thanks sintek.