How do I create a drop down list for selection.

If I want the following in my drop down list :-

89901 Blue Strips 1"
89902 Blue Strips 2"
90001 Red Strips 1"
90002 Red Strips 2"

Say if I select 89902 Red Strips 2" form the drop down list and only want
89902 to appear in the cell.

"tigermoth" wrote:

How do I create a drop down list for selection.

If I want the following in my drop down list :-

89901 Blue Strips 1"
89902 Blue Strips 2"
90001 Red Strips 1"
90002 Red Strips 2"

Say if I select 89902 Red Strips 2" form the drop down list and only want
89902 to appear in the cell.

Correction - Say if I select 89902 Blue Strips 2" form the drop down list
and only want 89902 to appear in the cell.

There is a sample file he

http://contextures.com/excelfiles.html#DataVal

Look for DV0004 - Data Validation Change

--
Biff
Microsoft Excel MVP


"tigermoth" wrote in message
...
How do I create a drop down list for selection.

If I want the following in my drop down list :-

89901 Blue Strips 1"
89902 Blue Strips 2"
90001 Red Strips 1"
90002 Red Strips 2"

Say if I select 89902 Red Strips 2" form the drop down list and only want
89902 to appear in the cell.