Thread: Data Validation - reference to another workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
skysusan skysusan is offline
external usenet poster
  
Posts: 6
Default Data Validation - reference to another workbook
How can I create a drop down list refering data in aonther workbook?

I have created a NAME (says CUSTCODE) referencing a list of customer codes
in another workbook. And I would like to make a drop-down list refering this
list, using the Data Validation, but it would not allow me to select this
reference name.
Reply With QuoteReply With Quote