validation

Q

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
 
P

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
 
Top