Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to name cells using same name yet specific to worksheet in Exc
How do I name a cell (e.g. StockPrice) on one worksheet (e.g. Worksheet A) in
an Excel file and reference it on that same sheet, then name another cell on a different worksheet (e.g. Worksheet B) within the same Excel file with the same StockPrice name and be able to reference it on the new sheet independent of Worksheet A? Looking for a way to worksheet specifically name cells so that I can reuse the same name on several worksheets and references to that name will only link to the name on that specific worksheet unless specified otherwise. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to name cells using same name yet specific to worksheet in Exc
If I'm understanding you correctly all you have to do is put the name of the
worksheet and an ! in front of your cell reference, i.e. =Worksheet B!D5 will reference cell D5 in Worksheet B HTH |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to name cells using same name yet specific to worksheet in Exc
on the other hand if the question was referring to "Defined Name"
you can have only one Defined Name with the same name in a workbook. Any attempt to place a sheetname in front of the defined name will get converted to the bookname. You can have the same defined name in different workbooks and include the workbook name before the exclamation point if not in the same workbook. value of A1 on sheet1 is 22 and has a defined name of _A1 value of A1 on sheet2 is 3 value formula as shown on Sheet2 for cells A1:A4 3 3 22 =_A1 22 =defined_name_2006_0313.xls!_A1 19 =_A1 - A1 --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "MartinW" wrote in message ... If I'm understanding you correctly all you have to do is put the name of the worksheet and an ! in front of your cell reference, i.e. =Worksheet B!D5 will reference cell D5 in Worksheet B HTH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i format inserted cells in protected worksheet? | Excel Worksheet Functions | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
highlight/color cells with specific character inside | Excel Worksheet Functions | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
embedding worksheet cells in another worksheet | Excel Discussion (Misc queries) |