ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula to populate a drop down list based on the selection of ano (https://www.excelbanter.com/excel-discussion-misc-queries/159927-formula-populate-drop-down-list-based-selection-ano.html)

Mekinnik September 27th 07 06:46 PM

Formula to populate a drop down list based on the selection of ano
 
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.

Harald Staff[_2_] September 27th 07 06:54 PM

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.




All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com