list:validation

[qwerty]

I want to do a validastion from a list. but the list is in an other sheet.
Excel don`t let me do this.

Is this a limitation of excel??

Regards in advance

[Peo Sjoblom]

Name the list under insert>name>define and then refer to the name i.e.

data>validation>list and in source box put

=MyList


Regards,

Peo Sjoblom


"qwerty" <[email protected]> wrote in message
news:[email protected]...
> I want to do a validastion from a list. but the list is in an other sheet.
> Excel don`t let me do this.
>
> Is this a limitation of excel??
>
> Regards in advance