software

Hello Everyone,

I want to create a drop down sublist, from a List. For example if you
choose apples from one list(drop Down) then you would receive the apples
sublist to choose from. If you choose pears from a list, then you receive
the pears sub list to choose from.

Im creating list using the normal quot;data validationquot; method in Excel 2003

Thanks.
--
Jeff

Check www.contextures.com/xlDataVal02.html

quot;GoBucksquot; wrote:

gt; Hello Everyone,
gt;
gt; I want to create a drop down sublist, from a List. For example if you
gt; choose apples from one list(drop Down) then you would receive the apples
gt; sublist to choose from. If you choose pears from a list, then you receive
gt; the pears sub list to choose from.
gt;
gt; Im creating list using the normal quot;data validationquot; method in Excel 2003
gt;
gt; Thanks.
gt; --
gt; Jeff

Worked Great thanks !
--
Jeffquot;bpeltzerquot; wrote:

gt; Check www.contextures.com/xlDataVal02.html
gt;
gt; quot;GoBucksquot; wrote:
gt;
gt; gt; Hello Everyone,
gt; gt;
gt; gt; I want to create a drop down sublist, from a List. For example if you
gt; gt; choose apples from one list(drop Down) then you would receive the apples
gt; gt; sublist to choose from. If you choose pears from a list, then you receive
gt; gt; the pears sub list to choose from.
gt; gt;
gt; gt; Im creating list using the normal quot;data validationquot; method in Excel 2003
gt; gt;
gt; gt; Thanks.
gt; gt; --
gt; gt; Jeff