Reference external data in drop-down lists

jeffk · #2 01-01-2016, 09:13 AM

Quote:

Originally Posted by jeffk

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?

Just to be clear - I know I can import data from non-spreadsheet external sources, but that seems to just put the data into visible cells, it's how to use it in a drop down list that I'm asking for help with.

Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word: external reference from other documents	twinclouds	Word	6	03-12-2015 12:08 AM
Drop down lists options	inq80	Excel	2	10-17-2014 08:05 AM
drop down list from external data source Excel 2007?	Intruder	Excel	1	08-03-2012 05:41 AM
Reference to an external filename which changes frequently	roooberta	Word	0	12-11-2008 07:33 AM
Drop Down Lists	Browett	Excel	0	12-19-2005 04:20 PM