Excel2002 named references

M

Michael Preminger

Hello!

I have a sheet with many named references to cells/regions.
I would like to copy it to a new sheet, with the same format, but
different data.

So I need the same named references, but they should be local to the new
sheet, and not point to the original sheet.

When I make a copy of the original sheet the named references in the new
sheet point to the original sheet, and changing each of them manually is
a nightmare.

How do I copy the original sheet so that it makes the named references
local?

Thanks

Michael
 
D

Dave Peterson

I'm confused with your use of Sheets.

Do you mean you have a worksheet with names on it that point at other sheets in
the same workbook and you want to copy that worksheet to a different workbook?

And you want the references in that copied workbook to point at existing
(similar) names in other worksheets in the new workbook?

If that made sense????

Then maybe you could either copy the worksheet and then
Edit|Links|change source

or maybe change all your formulas to constants, copy the constants, and then
convert them back to formulas (both the new worksheet and the old worksheet).

Edit|Replace
=
with
$$$$$$
(replace all)

Copy the worksheet to its new home.

Edit|replace
$$$$$$
with
=
(replace all)

In both the original and new workbook.

And if you're working with names, get Jan Karel Pieterse's (with Charles
Williams and Matthew Henson) Name Manager.

You can find it at:
NameManager.Zip from http://www.bmsltd.ie/mvp

And if you're working with links, get Bill Manville's FindLink program:
http://www.bmsltd.ie/MVP/Default.htm
 
Top