change cell names based on new sheet name

[tdebb8594]

I have a workbook that I frequently need to add new sheets using a template. I would like the template to included named cells. Is there a way to add copy the template and change the named cells to include the new sheet name? For instance:

If I have a sheet named Template with several named cells, one being TemplateSalaryTotal. When I copy the "Template" sheet to create a "NewSheet" I would like to change the name of all the named cells to begin with "NewSheet" rather than "Template".

Is this possible?

Thank you!

[Ron Coderre]

If you create sheet-level names, instead of workbook-level names, then each name will be unique to the sheet that contains it.
Which version of Excel are you using?
If Excel 2007 or above...here's how you create a sheet-level name:
• Formulas.Define_Name
...Name: (enter any valid name here)
...Scope: (select the sheet that the named cell is on)
...Refers to: (select the cell to be named)
...Click: OK

Example:
Cell C3 on Sheet1 is named rngTaxRate.
Enter 5% in that cell
Create a copy of Sheet1....Which will be Sheet1 (2)
Enter 10% in the copy

This formula on Sheet1 (2) returns: 10%
=rngTaxRate

However, THIS formula returns: 5%
=Sheet1!rngTaxRate

Is that something you can work with?