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