How do i use the same name multiple times in repeating worksheets

C

Chris.Daniels

I have multiple sheets doing the same calculation. Initially one was set up
and copied mutiple times. This created multiple range names with the same
name but within a sheet.

I now want to create an extra name within each of the 10 sheets but if i use
the same name it simply updates every sheet not each individual sheet.
 
B

Bob Phillips

When you create the name, precede it with the sheetname, such as

Sheet1!myName

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top