#1   Report Post  
Posted to microsoft.public.excel.misc
GoBucks
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
GoBucks
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Limit drop down list and linking to other info Intuit Excel Worksheet Functions 13 February 2nd 06 09:48 PM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM
advanced: synchronizing data value across two worksheet drop boxes mdhokie Excel Worksheet Functions 1 October 6th 05 08:46 PM
formulas for drop down menus Char Excel Discussion (Misc queries) 0 July 18th 05 07:29 PM
automatic color change in cells using a drop down list kennethwt Excel Worksheet Functions 1 January 21st 05 06:37 PM


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"