Hi

For a non-vba solution, try
http://www.contextures.com/xlDataVal13.html

HTH. Best wishes Harald

"Mekinnik" wrote in message
...
I am trying to create a worksheet to organize manufacturer and product
information. I have created a drop down list based on the manufacturers
name
from lets say sheet 1 and I have the manufacturers products on lets say
sheet
2, what I would like to be able to do on a whole nother worksheet (lets
say
sheet 3) is to have a drop down list populated with the products of the
manufacter (lets say on sheet 3 cell a1) when I select a manufacturer from
(lets say sheet 3 b1).

Another question: How would I link the manufacturers name to there various
products.