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
 

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

Similar Threads

Relative worksheet reference clarified 4
VBA - retrieve data on last create named range from previous inserted named range 0
Editing cell names 1
Chart references when copying worksheets 3
Change a cell reference from relative to absolute 2
Changing relative cell reference 2
Use of Indirect in Defined Name 5
copying worksheet including graphs to new worksheet 9

Back
Top