View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bigg19 Bigg19 is offline
external usenet poster
 
Posts: 7
Default 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