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.

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)

"Chris.Daniels" wrote in message
...
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.