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. |
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 03:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com