How do i use the same name multiple times in repeating worksheets
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.
|