Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 13th 05, 08:11 PM posted to microsoft.public.excel.misc
33zenlane
 
Posts: n/a
Default Define drop-down results that are variable and dependent upon the.

More Detail:
Drop-down defined in column C and I am wanting to create a drop-down in
column D that will only display specific values I define - however - it is
static list dependent upon what is selected in column C.

Example of Desired Result:
Cell C4 = 4 diffent options when click on drop down and I choose Cake (Cake,
Candy, Soda, Sugar).
Cell D4 = only display a list (I have to be able to choose just one from the
list) I have defined specific for Cake (cell C4 = Cake, cell D4 = a drop-down
list with the following as options - flour, water, sugar, baking soda - and I
can choose 1 of the 4 I need). However, if I choose Candy (cell C5 = candy,
cell D5 = a drop-down list with the following as options - sugar, powder
sugar, water, and wax - display in the drop down and I can choose 1 of the 4
I need.

  #2   Report Post  
Old December 13th 05, 08:47 PM posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Define drop-down results that are variable and dependent upon the.

Sounds like you want dependent lists.

See Debra Dalgleish's site for instructions.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben Excel MVP

On Tue, 13 Dec 2005 12:11:04 -0800, 33zenlane
wrote:

More Detail:
Drop-down defined in column C and I am wanting to create a drop-down in
column D that will only display specific values I define - however - it is
static list dependent upon what is selected in column C.

Example of Desired Result:
Cell C4 = 4 diffent options when click on drop down and I choose Cake (Cake,
Candy, Soda, Sugar).
Cell D4 = only display a list (I have to be able to choose just one from the
list) I have defined specific for Cake (cell C4 = Cake, cell D4 = a drop-down
list with the following as options - flour, water, sugar, baking soda - and I
can choose 1 of the 4 I need). However, if I choose Candy (cell C5 = candy,
cell D5 = a drop-down list with the following as options - sugar, powder
sugar, water, and wax - display in the drop down and I can choose 1 of the 4
I need.

  #3   Report Post  
Old December 13th 05, 09:41 PM posted to microsoft.public.excel.misc
Duke Carey
 
Posts: n/a
Default Define drop-down results that are variable and dependent upon the.

Debra Dalgliesh's site has a good tutorial on how to do just this:

http://contextures.com/xlDataVal02.html

"33zenlane" wrote:

More Detail:
Drop-down defined in column C and I am wanting to create a drop-down in
column D that will only display specific values I define - however - it is
static list dependent upon what is selected in column C.

Example of Desired Result:
Cell C4 = 4 diffent options when click on drop down and I choose Cake (Cake,
Candy, Soda, Sugar).
Cell D4 = only display a list (I have to be able to choose just one from the
list) I have defined specific for Cake (cell C4 = Cake, cell D4 = a drop-down
list with the following as options - flour, water, sugar, baking soda - and I
can choose 1 of the 4 I need). However, if I choose Candy (cell C5 = candy,
cell D5 = a drop-down list with the following as options - sugar, powder
sugar, water, and wax - display in the drop down and I can choose 1 of the 4
I need.

  #4   Report Post  
Old December 13th 05, 09:42 PM posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Define drop-down results that are variable and dependent upon the.

Check Debra Dalgleish's site:

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


Does that get you pointed in the right direction?

***********
Regards,
Ron


"33zenlane" wrote:

More Detail:
Drop-down defined in column C and I am wanting to create a drop-down in
column D that will only display specific values I define - however - it is
static list dependent upon what is selected in column C.

Example of Desired Result:
Cell C4 = 4 diffent options when click on drop down and I choose Cake (Cake,
Candy, Soda, Sugar).
Cell D4 = only display a list (I have to be able to choose just one from the
list) I have defined specific for Cake (cell C4 = Cake, cell D4 = a drop-down
list with the following as options - flour, water, sugar, baking soda - and I
can choose 1 of the 4 I need). However, if I choose Candy (cell C5 = candy,
cell D5 = a drop-down list with the following as options - sugar, powder
sugar, water, and wax - display in the drop down and I can choose 1 of the 4
I need.

  #5   Report Post  
Old December 13th 05, 09:42 PM posted to microsoft.public.excel.misc
33zenlane
 
Posts: n/a
Default Define drop-down results that are variable and dependent upon

Bless you! I have worked on this all day long.

Thanks,
Schuyler

"Ron Coderre" wrote:

Check Debra Dalgleish's site:

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


Does that get you pointed in the right direction?

***********
Regards,
Ron


"33zenlane" wrote:

More Detail:
Drop-down defined in column C and I am wanting to create a drop-down in
column D that will only display specific values I define - however - it is
static list dependent upon what is selected in column C.

Example of Desired Result:
Cell C4 = 4 diffent options when click on drop down and I choose Cake (Cake,
Candy, Soda, Sugar).
Cell D4 = only display a list (I have to be able to choose just one from the
list) I have defined specific for Cake (cell C4 = Cake, cell D4 = a drop-down
list with the following as options - flour, water, sugar, baking soda - and I
can choose 1 of the 4 I need). However, if I choose Candy (cell C5 = candy,
cell D5 = a drop-down list with the following as options - sugar, powder
sugar, water, and wax - display in the drop down and I can choose 1 of the 4
I need.



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
1-variable Data Table dependent on MS Query fails to update correctly [email protected] Excel Discussion (Misc queries) 0 March 30th 05 07:43 PM


All times are GMT +1. The time now is 01:47 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017