Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists that reference another workbook | Excel Discussion (Misc queries) | |||
One workbook to another . . . | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
drop down lists | New Users to Excel | |||
Drop Down Lists | Excel Worksheet Functions |