Copy Named Ranges from one workbook to a different one

[Peter Davison]

I have looked at previous answers to Copy Named Ranges from one workbook to a different one and I can't seem to make any work.
My Source Workbook with the named ranges (there are 29 named ranges) is - Micro Assortment Analysis v2.xlsm
and my destination workbook is - Micro Assortment Analysis Test with one data file.xlsm
Any help with some vba code or any other method would be great.

 

[jkpieterse]

Download my Name Manager. Open it against your source WB and click the List button (fourth btn from the left). Copy the newly inserted tab to the other workbook and open the NM dialog again. Click the Pickup button (next to List button).