View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Driver
 
Posts: n/a
Default How do I make a Validation List in Excel, using data on a second

I am making up an order form up with product codes and would like to ad in a
Validation List in Excel, using data on a second sheet, just can not get it
to look at another sheet in the work book?
and on the form can I ask it to only offer codes that match a selected
product discrioption which is on a validation list on the sceond sheet ??
Any help would be most greatful
Regards