Adding many dynamic formulas into Name Manager

[idiotechie]

I have made a table with many dynamic formulas that I want to import into the Name Manager. It has the names in Column A and the "Refers to" formulas in Column B. Unfortunately, when highlighting the cells and using the "Create from Selection" feature of Excel 2010 it puts the Column B cell address in the "Refers to" field, not the actual formula. Is there another way to get these formulas into the "Refers to" field without typing them all out or coping and pasting them individually?

Thanks,

Mike

 

[idiotechie]

Anyone??? Bump.

 

[idiotechie]

One more bump.

I am just looking for a way to import two columns (one for the name and one for what it refers to) into name manager. The "Refers To" column was created with CONCATENATE and has been copied and pasted as values.

Any thoughts?

 

[UseLessFuel]

I have the same issue. Was there a reply to this? Or, does the "Refers to" reference have to be hand-entered each time?