Reference external data in drop-down lists

		Microsoft Office Forums > Microsoft Excel > Excel
Reference external data in drop-down lists

FAQ

Thread Tools

Display Modes

12-23-2015, 05:42 AM

jeffk

Windows 7 64bit Reference external data in drop-down lists

Office 2007

Advanced Beginner

Join Date: Jul 2012

Location: North of England, UK

Posts: 32

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

Tags

data validation, drop down lists, external data

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:33 PM.