I have a list of 'name's' cells in my workbook used on sheet one.
How can I copy these same names and add a piece of text to create a similar set of named cells but on sheet 2?
I basically don't want to go through and name the fields again on sheet2.
I understand I can't use the same 'name' twice in a workbook so I want to slightly amend the name of the same range of named fields.
How can I copy these same names and add a piece of text to create a similar set of named cells but on sheet 2?
I basically don't want to go through and name the fields again on sheet2.
I understand I can't use the same 'name' twice in a workbook so I want to slightly amend the name of the same range of named fields.