inserting drop down list option for the entire workbook with Mold Name as unique identifier

Anthonymu

New Member
Joined
May 3, 2019
Messages
1
[TABLE="width: 688"]
<colgroup><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]MOLD NAME[/TD]
[TD]DATE RECEIVED[/TD]
[TD]DRAWING NO.[/TD]
[TD]DESIGN WEIGHT[/TD]
[TD]FINISH[/TD]
[TD]TYPE[/TD]
[/TR]
[TR]
[TD]200ML UGANDA WARAGI[/TD]
[TD]11/02/2016[/TD]
[TD]1031-BDS-M-MCVA[/TD]
[TD]205+/-10 GRAMS[/TD]
[TD]28/38 STEEL CAP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]200ML UGANDA WARAGI[/TD]
[TD]07/03/2017[/TD]
[TD]10313-BDS-M-MDVA[/TD]
[TD]185+/-10 GRAMS[/TD]
[TD]28 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]200ML K-VANT[/TD]
[TD]24/10/2017[/TD]
[TD]MGW 10365[/TD]
[TD]230+/-12 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]200ML GENERIC (GM)[/TD]
[TD]24/10/2017[/TD]
[TD]MGW 10358[/TD]
[TD]175+/-12 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]200ML JEBEL SPECIAL[/TD]
[TD]16/06/2018[/TD]
[TD]MGW 10334[/TD]
[TD]210+/-12 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]200ML LN[/TD]
[TD]06/03/2019[/TD]
[TD]MGW 10447[/TD]
[TD]210+/-12 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]200ML FURAHA[/TD]
[TD]26/08/2011[/TD]
[TD]MGW 10095[/TD]
[TD]245+/-12 GRAMS[/TD]
[TD]28 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]MOLD NAME[/TD]
[TD]DATE RECEIVED[/TD]
[TD]DRAWING NO.[/TD]
[TD]DESIGN WEIGHT[/TD]
[TD]FINISH[/TD]
[TD]TYPE[/TD]
[/TR]
[TR]
[TD]205ML GENERIC[/TD]
[TD]09/05/2018[/TD]
[TD]MGW 10169[/TD]
[TD]170+/-12 GRAMS[/TD]
[TD]28 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]205ML UBL GM[/TD]
[TD]13/04/2015[/TD]
[TD]100126-BDS-M-MDVA[/TD]
[TD]210+/-12 GRAMS[/TD]
[TD]31.5 ROPP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]205ML GM[/TD]
[TD]27/05/2016[/TD]
[TD]100126-BDS-M-MDVA[/TD]
[TD]210+/-12 GRAMS[/TD]
[TD]31.5 ROPP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]205ML FLYING HORSE (LOGO)[/TD]
[TD]20/10/2013[/TD]
[TD]10161-BDS-M-MCVA[/TD]
[TD]170+/-12 GRAMS[/TD]
[TD]28 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]205ML FLYING HORSE (PLAIN)[/TD]
[TD]15/01/2014[/TD]
[TD]10161-BDS-M-MCVA[/TD]
[TD]170+/-12 GRAMS[/TD]
[TD]28PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]205ML BISCEPT (BL/GENERIC)[/TD]
[TD]17/03/2015[/TD]
[TD]10210-BDS-M-MDVA[/TD]
[TD]210+/-12 GRAMS[/TD]
[TD]31.5 ROPP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]205ML MEGATRADE[/TD]
[TD]05/04/2013[/TD]
[TD]10145-BDS-M-BPVA[/TD]
[TD]255+/-12 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]MOLD NAME[/TD]
[TD]DATE RECEIVED[/TD]
[TD]DRAWING NO.[/TD]
[TD]DESIGN WEIGHT[/TD]
[TD]FINISH[/TD]
[TD]TYPE[/TD]
[/TR]
[TR]
[TD]250ML ASL LION LOGO 4.25"[/TD]
[TD]07/04/2018[/TD]
[TD]MGW 10331[/TD]
[TD]235+/-15 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML ASL LION LOGO ROUND 5"[/TD]
[TD]20/12/2018[/TD]
[TD]MGW 10412[/TD]
[TD]235+/-15 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML VAN ROH ROUND[/TD]
[TD]19/11/2015[/TD]
[TD]MGW 10219[/TD]
[TD]255+/-12 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML LDK GUALA[/TD]
[TD]09/01/2017[/TD]
[TD][/TD]
[TD]240 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML LDK GUALA ROUND[/TD]
[TD]02/10/2018[/TD]
[TD]MGW 10385[/TD]
[TD]230+/-12 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML K-VANT[/TD]
[TD]02/12/2015[/TD]
[TD]MGW 10225[/TD]
[TD]255+/-12 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML KENYA CANE 4.25"[/TD]
[TD]09/05/2018[/TD]
[TD]10277-BDS-M-MCVA[/TD]
[TD]230+/-10 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML KENYA CANE 5"[/TD]
[TD]07/06/2018[/TD]
[TD]10277-BDS-M-MCVA[/TD]
[TD]230+/-10 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML FRM (LOGO)[/TD]
[TD]08/11/2018[/TD]
[TD]MGW10397[/TD]
[TD]250+/-12 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML FRM ROUND[/TD]
[TD]08/11/2018[/TD]
[TD]MGW 10409[/TD]
[TD]230+/-12 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML RDL ROUND[/TD]
[TD]17/01/2019[/TD]
[TD]MGW 10417[/TD]
[TD]230+/-12 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML RDL FLASK[/TD]
[TD]28/01/2019[/TD]
[TD]MGW 10437[/TD]
[TD]235+/-15 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML RDL FLAT[/TD]
[TD]27/02/2019[/TD]
[TD]MGW 10434[/TD]
[TD]235+/-15 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML SUNDRY GM[/TD]
[TD]17/03/2015[/TD]
[TD]10143-BDS-M-MDVA[/TD]
[TD]235+/-17 GRAMS[/TD]
[TD]30PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML SUNDRY EABL[/TD]
[TD]17/12/2013[/TD]
[TD][/TD]
[TD]235+/-17 GRAMS[/TD]
[TD]30PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML SUNDRY EABL GUALA[/TD]
[TD]07/04/2018[/TD]
[TD]10304-BDS-M-MCVA[/TD]
[TD]250+/-10 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML EABL GENERIC (CPT MORGAN)[/TD]
[TD]19/01/2019[/TD]
[TD]MGW 10449[/TD]
[TD]215+/-10 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML GM BOTTLE[/TD]
[TD]08/09/2017[/TD]
[TD]MGW 10344[/TD]
[TD]220+/-12 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML GM GUALA[/TD]
[TD]27/02/2019[/TD]
[TD]10249-BDS-M-MCVA[/TD]
[TD]220+/-12 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML FURAHA[/TD]
[TD]26/08/2011[/TD]
[TD]10095-BDS-M-BVL[/TD]
[TD]300+/-15 GRAMS[/TD]
[TD]28 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML GRAND BEVERAGE[/TD]
[TD]21/07/2013[/TD]
[TD]10162-BDS-M-MDVA[/TD]
[TD]235+/-12 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML GENERIC[/TD]
[TD]13/02/2012[/TD]
[TD]MGW 10083[/TD]
[TD]230+/-12 GRAMS[/TD]
[TD]31.5 ROPP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML FLYING HORSE[/TD]
[TD]01/12/2014[/TD]
[TD]MGW 10197[/TD]
[TD]235+/-12 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]250ML BISCEPT[/TD]
[TD]13/09/2018[/TD]
[TD]MGW 10395[/TD]
[TD]235+/-12 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]MOLD NAME[/TD]
[TD]DATE RECEIVED[/TD]
[TD]DRAWING NO.[/TD]
[TD]DESIGN WEIGHT[/TD]
[TD]FINISH[/TD]
[TD]TYPE[/TD]
[/TR]
[TR]
[TD]300ML SNAPP[/TD]
[TD]19/10/2011[/TD]
[TD]10114-BDS-M-MDVA[/TD]
[TD]275+/-12 GRAMS[/TD]
[TD]26-600[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]330ML BEER[/TD]
[TD]10/06/2011[/TD]
[TD]10101-BDS-M-MDVA[/TD]
[TD]265+/-16 GRAMS[/TD]
[TD]26-600[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]MOLD NAME[/TD]
[TD]DATE RECEIVED[/TD]
[TD]DRAWING NO.[/TD]
[TD]DESIGN WEIGHT[/TD]
[TD]FINISH[/TD]
[TD]TYPE[/TD]
[/TR]
[TR]
[TD]350ML DDL OVAL FLASK[/TD]
[TD]14/12/2012[/TD]
[TD][/TD]
[TD]340+/-17 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]SG[/TD]
[/TR]
[TR]
[TD]350ML ASL LION LOGO FLASK[/TD]
[TD]06/11/2017[/TD]
[TD]MGW 10332[/TD]
[TD]340+/-10 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]SG[/TD]
[/TR]
[TR]
[TD]350ML UGANDA WARAGI[/TD]
[TD]25/02/2016[/TD]
[TD]10230-BDS-M-MCVA[/TD]
[TD]320+/-12 GRAMS[/TD]
[TD]38/48 STEEL CAP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]350ML KENYA CANE[/TD]
[TD]07/06/2016[/TD]
[TD]10276-BDS-M-MCVA[/TD]
[TD]300+/-10 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]350ML FRM (LOGO)[/TD]
[TD]06/12/2018[/TD]
[TD]MGW 10401[/TD]
[TD]340+/-15 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]350ML FRM (PLAIN)[/TD]
[TD]06/12/2018[/TD]
[TD]MGW 10410[/TD]
[TD]320+/- 15 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]350ML SUNDRY OVAL FLASK[/TD]
[TD]26/08/2011[/TD]
[TD]10104-BSG-M-MCRA[/TD]
[TD]340+/-17 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]SG[/TD]
[/TR]
[TR]
[TD]MOLD NAME[/TD]
[TD]DATE RECEIVED[/TD]
[TD]DRAWING NO.[/TD]
[TD]DESIGN WEIGHT[/TD]
[TD]FINISH[/TD]
[TD]TYPE[/TD]
[/TR]
[TR]
[TD]500ML VINEPACK (ADL)[/TD]
[TD]11/06/2013[/TD]
[TD]10154-BDS-M-MCVA[/TD]
[TD]450+/-15 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]500ML RDL FLAT[/TD]
[TD]27/02/2019[/TD]
[TD]MGW 10436[/TD]
[TD]380+/-15 GRAMS[/TD]
[TD]G-NIP[/TD]
[TD]SG[/TD]
[/TR]
[TR]
[TD]MOLD NAME[/TD]
[TD]DATE RECEIVED[/TD]
[TD]DRAWING NO.[/TD]
[TD]DESIGN WEIGHT[/TD]
[TD]FINISH[/TD]
[TD]TYPE[/TD]
[/TR]
[TR]
[TD]750ML IDV WHISKEY[/TD]
[TD]18/05/2016[/TD]
[TD]10105-BSG-M-MDRA[/TD]
[TD]507+/-17 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]SG[/TD]
[/TR]
[TR]
[TD]750ML DDL SQUARE BOTTLE[/TD]
[TD]15/11/2012[/TD]
[TD]10127-BSG-M-BPRA[/TD]
[TD]570+/-17 GRAMS[/TD]
[TD]GUALA[/TD]
[TD]SG[/TD]
[/TR]
[TR]
[TD]750ML ASL[/TD]
[TD]22/04/2013[/TD]
[TD]10155-BSG-M-MDRA[/TD]
[TD]500+/-15 GRAMS[/TD]
[TD]30 PP [/TD]
[TD]SG[/TD]
[/TR]
[TR]
[TD]750ML ASL GUALA[/TD]
[TD]10/01/2014[/TD]
[TD]10193-BDS-M-MCVA[/TD]
[TD]500+/-15 GRAMS[/TD]
[TD]1031 GUALA[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]750ML ASL GUALA ROUND 5''[/TD]
[TD]20/12/2018[/TD]
[TD]MGW 10439[/TD]
[TD]500+/-17 GRAMS[/TD]
[TD]1031 GUALA[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]750ML VINEPACK ROUND[/TD]
[TD]03/05/2013[/TD]
[TD]10153-BSG-M-FL[/TD]
[TD]550+/-17 GRAMS[/TD]
[TD]30PP[/TD]
[TD]SG[/TD]
[/TR]
[TR]
[TD]750ML CONTESSA RUM[/TD]
[TD]26/07/2013[/TD]
[TD]10164-BSG-M-MCRA[/TD]
[TD]550+/-17 GRAMS[/TD]
[TD]GUALA[/TD]
[TD]SG[/TD]
[/TR]
[TR]
[TD]750ML VAN ROH ROUND[/TD]
[TD]19/11/2015[/TD]
[TD]10218-BSG-M-MDRA[/TD]
[TD]525+/-17 GRAMS[/TD]
[TD]30 SCNSB[/TD]
[TD]SG[/TD]
[/TR]
[TR]
[TD]750ML GILBEY GIN[/TD]
[TD]20/09/2014[/TD]
[TD]10192-BSG-M-MDRA[/TD]
[TD]525+/- 20 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]SG[/TD]
[/TR]
[TR]
[TD]750ML UGANDA WARAGI[/TD]
[TD]26/06/2015[/TD]
[TD]MGW 10223[/TD]
[TD]505 +/-17 GRAMS[/TD]
[TD]30 STEEL CAP[/TD]
[TD]SG[/TD]
[/TR]
[TR]
[TD]750ML LDK GUALA[/TD]
[TD]27/11/2018[/TD]
[TD]10227-BDS-M-MDVA[/TD]
[TD]500+/-17 GRAMS[/TD]
[TD]1031 GUALA[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]750ML K-VANT[/TD]
[TD]22/12/2015[/TD]
[TD]MGW 10226[/TD]
[TD]540+/-17 GRAMS[/TD]
[TD]1031 GUALA[/TD]
[TD]SG[/TD]
[/TR]
[TR]
[TD]750ML KENYA CANE[/TD]
[TD]15/06/2016[/TD]
[TD]10278-BDS-M-MCVA[/TD]
[TD]440+/-17 GRAMS[/TD]
[TD]1031 GUALA[/TD]
[TD]DG[/TD]
[/TR]
[TR]
[TD]750ML FRM ROUND (LOGO)[/TD]
[TD]06/12/2018[/TD]
[TD]MGW10411[/TD]
[TD]500+/-18 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]SG[/TD]
[/TR]
[TR]
[TD]750ML FRM ROUND (PLAIN)[/TD]
[TD]06/12/2018[/TD]
[TD]MGW 10403[/TD]
[TD]500+/-18 GRAMS[/TD]
[TD]30 PP[/TD]
[TD]SG[/TD]
[/TR]
[TR]
[TD]750ML RDL BOTTLE[/TD]
[TD]17/01/2019[/TD]
[TD]MGW 10418[/TD]
[TD]480+/-18 GRAMS[/TD]
[TD]1031/59 GUALA[/TD]
[TD]DG[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,224,823
Messages
6,181,184
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top