How do i use the same name multiple times in repeating worksheets
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. |
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. |
All times are GMT +1. The time now is 06:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com