relative defined name references?

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top