Copying Defined Names in Excel
EE Pros,
I have a large number of "Range Names" that I'm trying to copy from one Worksheet to another. There doesn't seem to be an easy way to do this; forcing me to redo each of the Range names. Is there a way to copy a number of Range names at one time from one Workbook to another.
Thank you in advance.
B.
I have a large number of "Range Names" that I'm trying to copy from one Worksheet to another. There doesn't seem to be an easy way to do this; forcing me to redo each of the Range names. Is there a way to copy a number of Range names at one time from one Workbook to another.
Thank you in advance.
B.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ejgil Hedegaard
If you copy the sheet to the other workbook, all names with reference to that sheet, will also be copied to the new workbook, and have the same sheet references.
ASKER
Is there any way to copy (besides one at a time) without using a Macro? And if I do use the Macro, do I put it in a Module in the target WB or the specific target WS?
Thank you,
B.
Thank you,
B.
You can try hgholt's suggestion for a non-macro solution.
If you use the macro, place it in either workbook in a module. As long as you have the source workbook active when you execute it.
Joop
If you use the macro, place it in either workbook in a module. As long as you have the source workbook active when you execute it.
Joop
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hgholt,
Just to be clear, I'm trying to copy "names" (Formulas; Range Names) over. I understand that if I copy a sheet or multiple sheets the range names come over, but if I'm simply coming Range Names in the Name Manager, I can not seem to copy multiple names at one time. That means if I don't copy the sheets but want to copy the Names, I have to recreate the Names one at a time. That's what I'm trying to see if there is a way to simply copy and paste or drop and drag.
Does your approach by coping over the sheets and then not activating them.....will that work?
B.
Just to be clear, I'm trying to copy "names" (Formulas; Range Names) over. I understand that if I copy a sheet or multiple sheets the range names come over, but if I'm simply coming Range Names in the Name Manager, I can not seem to copy multiple names at one time. That means if I don't copy the sheets but want to copy the Names, I have to recreate the Names one at a time. That's what I'm trying to see if there is a way to simply copy and paste or drop and drag.
Does your approach by coping over the sheets and then not activating them.....will that work?
B.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys; I can use all of these methods but I really like the utility!
All the best,
B.
All the best,
B.
Well thanks Rob!