View Single Post
  #2   Report Post  
Old September 27th 07, 06:54 PM posted to microsoft.public.excel.misc
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 449
Default Formula to populate a drop down list based on the selection of ano

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.