Copying Defined Names

[JP]

Greetings:

When using Excel 2003, how do I copy or move (or otherwise get) defined
names from one workbook to another intact? When I copy (or move) a sheet
from one workbook to another, the defined names go with it, but the defined
names' references changes. (For example, a defined name's range that
includes the sheet name "Sheet2" becomes "#Ref.") I need to do this often
and I have a great many defined names that I need to keep. (The sheets
have identical names in both workbooks).

Thank you,
JP

 

[Fredrik Wahlgren]

Greetings:

When using Excel 2003, how do I copy or move (or otherwise get) defined
names from one workbook to another intact? When I copy (or move) a sheet
from one workbook to another, the defined names go with it, but the defined
names' references changes. (For example, a defined name's range that
includes the sheet name "Sheet2" becomes "#Ref.") I need to do this often
and I have a great many defined names that I need to keep. (The sheets
have identical names in both workbooks).

Thank you,
JP

If you want to move defined names, you really should create them in a macro.
The macro can then easily be moved.

/Fredrik

 

[JP]

If you want to move defined names, you really should create them in a
macro. The macro can then easily be moved.

/Fredrik

Well, sure, I didn't think of that. I'll try it that way.

Thanks and best regards,
JP