Dynamic Drop Down List

[GLower0617]

First post on this forum so Hello to everyone.........

I am trying to create a dynamic drop down list differently than I have done before. I have done the dynamic list with named ranges and index matching within a table. I am trying to return the value in column A if there is a value in the table match. We produce bottles and we dont produce all bottles on all lines. We also produce them at different speeds on each line in some cases. I have a production spreadsheet where the line # is static and I want to create a drop down list of the bottles that are actually produced on the line. This would help minimize selection error by the user. The matrix or table I am referencing is used also for a index match to find the correct speed and I was trying to prevent creating mutiple tables for each line containing the bottles each one produces.

For line 1 I would like to populate a dropdown list of Bottle 1 through Bottle 11, and Bottle 27 by looking to see if there is a value in column Line 1.

Thanks,
Gary

	Line 1	Line 2	Line 3	Line 4	Line 5	Line 6	Line 7
Bottle 1	5100	5100	5100				5100
Bottle 2	4800	4800	4800				4800
Bottle 3	5700	5700	5700				5700
Bottle 4	4800	4800	4800				4800
Bottle 5	4600	4600	4600				4600
Bottle 6	5400	5400	5400				5400
Bottle 7	5400	5400	5400				5400
Bottle 8	5400	5400	5400				5400
Bottle 9	5400	5400	5400				5400
Bottle 10	5700	5700	5700				5700
Bottle 11	5400	5400	5400				5400
Bottle 12				6000	6000	6000	6000
Bottle 13				6000	6000	6000	6000
Bottle 14				6000	6000	6000	4800
Bottle 15				6000	6000	6000	4800
Bottle 16				6000	6000	6000	6000
Bottle 17				6000	6000	6000	6000
Bottle 18				6000	6000	6000	6000
Bottle 19				6000	6000	6000	6000
Bottle 20				6000	6000	6000	6000
Bottle 21							5000
Bottle 22				6000	6000	6000	6000
Bottle 23				6000	6000	6000	5000
Bottle 24				6000	6000	6000	6000
Bottle 25				6000	6000	6000	6000
Bottle 26				6000	6000	6000	6000
Bottle 27	6468	6468	6468				6468
Bottle 28				6000	6000	6000	6000

<colgroup><col style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;" width="66"> <col style="width: 48pt;" span="7" width="64"> <tbody>
</tbody>

 

[GLower0617]

I forgot to mention that this is a macro enabled workbook so VBA is an option although I would prefer another method since I want to use this in another non-macro workbook.