Thread: Reference external data in drop-down lists
View Single Post
 
Old 12-23-2015, 05:42 AM
jeffk jeffk is offline Windows 7 64bit Office 2007
Advanced Beginner
  
Join Date: Jul 2012
Location: North of England, UK
Posts: 32
jeffk is on a distinguished road
Default Reference external data in drop-down lists
I'm prepping for the Excel Expert 2007 exam & one of the things I need to know is how to "Reference external data in drop-down lists"

I know how to create a data validation drop-down list that references data in another workbook..........is it possible to do it with data from a non-spreadsheet file e.g word or access & if so how do I do so?

TIA
Reply With Quote