relative defined name references?

[Gant]

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)?

 

[Gord Dibben]

One method

In sheet1 insert>name>define

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