If you give that list on the secondary sheet a nice name, you can use it in your
data|validation.

See Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html#Name

"Pierre via OfficeKB.com" wrote:

Hi,

If i use datavalidation and use a list to choose from, i can only make a list
on the same sheet where the cells are with data validation.
how can i have a list to choose from that is on another sheet ?
Thanks,
Pierre

--
Message posted via http://www.officekb.com

--

Dave Peterson