| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down List Referring to a Named Range on Different Workshe
Thanks
It worked fine "Ben McBen" wrote: Hi Sounds like data validation would work well for you. Create a named range of your departments "Depts". Then select the range where you want the drop downs, and go to the Data - Validation menu. From the drop down select "list" and in the source input box type "=Depts" (no quotes) "Bigg19" wrote: 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
