View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default data validation on other sheet

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