Copying named lists used in drop downs from one workbook to anothe
 

Hello -

I have created named lists in one of the tabs of a worksheet that are used
with drop down menus in another worksheet within the same workbook. I want
to use the same list in a new workbook. When I copy the worksheet contents
and do past special/all the list choices are fine but I lose the names for
that range of cells. Is there some way to keep the range names intact when I
copy from one workbook to another do that I don't have to rename every column
again?