Drop Down Sublist
 

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 "data validation" method in Excel 2003

Thanks.
--
Jeff

Drop Down Sublist
 

Check http://www.contextures.com/xlDataVal02.html

"GoBucks" wrote:

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 "data validation" method in Excel 2003

Thanks.
--
Jeff

Drop Down Sublist
 

Worked Great thanks !
--
Jeff


"bpeltzer" wrote:

Check http://www.contextures.com/xlDataVal02.html

"GoBucks" wrote:

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 "data validation" method in Excel 2003

Thanks.
--
Jeff