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