Data validation list

[SPLUCENA]

Hi,,



Is it possible in data validation to have a list from other sheet? Example:my list is in Sheet of the same workbook.

thanks,


splucena

 

[KSTWS]

Name the Range where your data is.
Refer with Data Validation to this (list) named range.

 

[SPLUCENA]

Hi KSTWS,

I tried that but it I cannot move on the other sheet as to where my list is.

thanks,

splucena

 

[KSTWS]

First go to the sheet where your data is.
Select the data you want to use.

2007: Go to Formulas - Name Manager...
Select New...
type in a name for your range ex MyData.
OK

Goto the sheet where you want you data validation.
As source type: =MyData

 

[Legacy 68668]

Have you tried Indirect function ?

=Indirect("OtherSheetName!A1:A100")

 

[SPLUCENA]

Hi KSTWS,

My company is still using office 2003

and SEIYA,

The indirect formula gives me a message " The source currently evaluates to an error. Do you wish to continue?" I chose to click yes yet there is no list on the dropdown.

thanks,
splucena

 

[Legacy 68668]

Can you show me your actual formula ?

 

[SPLUCENA]

=indirect("DATA BANK!M1:M28")

 

[Legacy 68668]

=indirect("'DATA BANK'!M1:M28")

 

[SPLUCENA]

Thanks SEIYA, your formula worked! That was a one of a heck formula! How did you figure it out?