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
|