View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default changing validation drop down based on another cell value

have a look at this site.
http://www.contextures.com/xlDataVal02.html
--
jb


"pawlingJohn" wrote:

I need to change the drop-down list in a validation based on what is entered
in another cell. The other cell will be a vendor name and the list should be
product codes for that vendor.

thanks