local named references in a sheet

M

Michael Preminger

Hello! (this may be a repitition of a message I think I succeeded in
seding previously, but cant retrieve, so Im trying again. Appologize!)

I am trying to copy a sheet with many named references into a new sheet
(same workbook), but I want the new sheet to have the references local
to it, so I can experiment with different data on the same calculations.

The references hold intermediary values.

When I try to copy the original sheet, the named references in the copy
point to the original sheet.

How do I copy it "correctly"?

Thanks
 
J

Jan Karel Pieterse

Hi Michael,
When I try to copy the original sheet, the named references in the copy
point to the original sheet.
Click to expand...

Your first message did come through.

If you use defined names a lot, consider downloading the
Name manager (by Charles Williams, Matthew Henson and
myself) from:

www.jkp-ads.com

or

www.bmsltd.ie/mvp

or from:

www.decisionmodels.com/downloads.htm

It will show you what happens to your names and also gives you tools to
easily edit them.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Top