Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I reuse the same Name on more than one worksheet?
I have a multiple worksheets in my workbook. I want to name a cell on each
workbook by the same name "Litres" - note: I do NOT want a 3D reference to all at once, but individual references. On the same spreadsheet somehow I've managed this before - I have a name "Business" that is context-specific on whichever sheet I happen to be on, but I can't remember how I created it! Looking at at in the 'Names' dialog box, it appears in the list as: Business June ....where 'June' is the current sheet name. Can anyone help me with creating a reference like this? |
#3
|
|||
|
|||
Hi
When you name your cells, you need to prefix the name with the sheet ref eg sheet1!top, sheet2!top etc Hope this helps. -- Andy. "Trevor Heywood" <Trevor wrote in message ... I have a multiple worksheets in my workbook. I want to name a cell on each workbook by the same name "Litres" - note: I do NOT want a 3D reference to all at once, but individual references. On the same spreadsheet somehow I've managed this before - I have a name "Business" that is context-specific on whichever sheet I happen to be on, but I can't remember how I created it! Looking at at in the 'Names' dialog box, it appears in the list as: Business June ...where 'June' is the current sheet name. Can anyone help me with creating a reference like this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to reuse formatted worksheets from 2004 in 2005 | Excel Worksheet Functions |