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!!