| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
relative defined name references?
I'm trying to copy an excel template that has naming references included.
Is there a way to copy the template to a new worksheet within the existing spreadsheet, but have the naming references be relative (pointing to the current worksheet) as opposed to absolute (pointing to the previous worksheet)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
relative defined name references?
One method
In sheet1 insertnamedefine myrange refers to =INDIRECT(A1:A10) Note: you will not see this name in the namebox. To access hit F5 and type in myrange But you can use it in formulas like =SUM(myrange) for whatever sheet is active. Gord Dibben MS Excel MVP On Mon, 9 Nov 2009 08:20:01 -0800, Gant wrote: I'm trying to copy an excel template that has naming references included. Is there a way to copy the template to a new worksheet within the existing spreadsheet, but have the naming references be relative (pointing to the current worksheet) as opposed to absolute (pointing to the previous worksheet)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| Relative references | Excel Discussion (Misc queries) | |||
| Relative references | Excel Worksheet Functions | |||
| Defined name Relative to sheets | Excel Worksheet Functions | |||
Linear Mode
