relative defined name references?

  • Thread starter Thread starter Gant
  • Start date Start date
G

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