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
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 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks