using a list to validate from different sheet

[paritoshmehta]

I am trying to insert data validation (drop down list) but want the lis
to be placed in a different sheet, is that possible?

 

[Frank Kabel]

Hi
try the following:
- select your list on the separate sheet
- define a name for this list (Insert - Name - Define')
- use this name as datasource in the data validation dialog. e.g.
=list_with_values_name

 

[Bob Umlas]

Name the range from the 2nd sheet, like "MyList",
then use =MyList in the data validation. Works fine.
Bob Umlas
Excel MVP

 

[CLR]

The Validation List has to be on the same sheet, but you can use it to link
to data on another sheet............=Sheet2!F1, etc

Vaya con Dios,
Chuck, CABGx3

 

[Dreamboat]

Use the method described here:
http://www.theofficeexperts.com/excel.htm#DropdownLists

By using a named range instead of a range of cells, it can be done.

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Anne Troy
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com

 

[paritoshmehta]

Thank you all for the help!!!

 

[Max]

Just for completeness .. as it wasn't mentioned in the earlier responses
do also check out Debra D's nice coverage of Data Validation at :

http://www.contextures.com/xlDataVal01.html