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

Name the list under insertnamedefine and then refer to the name i.e.

datavalidationlist and in source box put

=MyList


Regards,

Peo Sjoblom


"qwerty" wrote in message
...
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