Data Validation List from different sheet

's Computer Specifications

In Excel 2003, can I use a data-validation drop-down list that reads
its data from a different sheet?

thanks

M

's Computer Specifications

Use a defined range as the source for the DV. Then you can.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Michelle" wrote:
> In Excel 2003, can I use a data-validation drop-down list that reads
> its data from a different sheet?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
data validation list form sheet	dlotz@uafc.com	Microsoft Excel Worksheet Functions	1	24th Jan 2009 12:12 AM
Data Validation List from different sheet	Michelle	Microsoft Excel Discussion	22	6th Jan 2009 06:56 PM
combo box from data validation with source list in separate sheet	=?Utf-8?B?SmF5IFRydWxs?=	Microsoft Excel Worksheet Functions	6	7th Mar 2006 01:59 AM
List, Data Validation, unlocked cell, protected sheet.....	=?Utf-8?B?S2FuZQ==?=	Microsoft Excel New Users	5	8th Jan 2005 10:39 PM
Can't use reference to another sheet in Data\|Validation\|Allow List?	Chip Pearson	Microsoft Excel Misc	4	31st Jul 2003 04:57 AM