Insert = Name = Define
Name: List1
RefersTo: =Sheet3!$A$1:$A$20
Click the Add Button
then in data validation under source put in
=List1
--
Regards,
Tom Ogilvy
"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:58bc677c6ce89@uwe...
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