| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down List Referring to a Named Range on Different Worksheet
I have a Receipt list set up in a spreadsheet, with a list of departments on
a separate sheet in the same workbook, named "DeptList". How do I set up a dropdown list next to each receipt number listed down the page that lists the departments to which the receipt can be assigned? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referring to a named range | Excel Programming | |||
| How do I use indirect when referring to a named range in a closed | Excel Worksheet Functions | |||
| Excel Drop down List with Named Range | Excel Programming | |||
| How can I use a named range for "pick from drop-down list"? | Excel Discussion (Misc queries) | |||
| referring to a named range on another worksheet | Excel Programming | |||
Threaded Mode
