Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael
 
Posts: n/a
Default data validation--multiple dependent list

Hi all,

Does anyone know how to create two list in different cells based on the
selection of the first list?

For example, i have one drop down list with these items: A, B ,C, D.

If 'A' is chosen, then i have two seperate cells that are dependent on the
selection of 'A' with their own list of values. 'A' has values of "A1, A2."

And 'A1' has list of 1,2,3,4
'A2' has list of 5,6,7,8.


I hope someone can help. Thanks in advance.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default data validation--multiple dependent list

Debra Dalgleish knows how:
http://contextures.com/xlDataVal02.html

Michael wrote:

Hi all,

Does anyone know how to create two list in different cells based on the
selection of the first list?

For example, i have one drop down list with these items: A, B ,C, D.

If 'A' is chosen, then i have two seperate cells that are dependent on the
selection of 'A' with their own list of values. 'A' has values of "A1, A2."

And 'A1' has list of 1,2,3,4
'A2' has list of 5,6,7,8.

I hope someone can help. Thanks in advance.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
Michael
 
Posts: n/a
Default data validation--multiple dependent list

Hey Dave,

Thanks for your reply. I have already looked at that particular example
posted on the website. However, it does not say anything about muliple lists
that depends on the first selection. The examples on the website talks
mainly about just one list dependent on the first choice, using the indirect
function in data validation.

I have two different cells that are dependent on what is selected in the
first cell...I hope i am being clear.

"Dave Peterson" wrote:

Debra Dalgleish knows how:
http://contextures.com/xlDataVal02.html

Michael wrote:

Hi all,

Does anyone know how to create two list in different cells based on the
selection of the first list?

For example, i have one drop down list with these items: A, B ,C, D.

If 'A' is chosen, then i have two seperate cells that are dependent on the
selection of 'A' with their own list of values. 'A' has values of "A1, A2."

And 'A1' has list of 1,2,3,4
'A2' has list of 5,6,7,8.

I hope someone can help. Thanks in advance.


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default data validation--multiple dependent list

Do the first cell following Debra's instructions.

Then do the second cell following the same instructions.

I don't understand why that wouldn't work.

Michael wrote:

Hey Dave,

Thanks for your reply. I have already looked at that particular example
posted on the website. However, it does not say anything about muliple lists
that depends on the first selection. The examples on the website talks
mainly about just one list dependent on the first choice, using the indirect
function in data validation.

I have two different cells that are dependent on what is selected in the
first cell...I hope i am being clear.

"Dave Peterson" wrote:

Debra Dalgleish knows how:
http://contextures.com/xlDataVal02.html

Michael wrote:

Hi all,

Does anyone know how to create two list in different cells based on the
selection of the first list?

For example, i have one drop down list with these items: A, B ,C, D.

If 'A' is chosen, then i have two seperate cells that are dependent on the
selection of 'A' with their own list of values. 'A' has values of "A1, A2."

And 'A1' has list of 1,2,3,4
'A2' has list of 5,6,7,8.

I hope someone can help. Thanks in advance.


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default data validation--multiple dependent list

I believe Debra posted a sample file recently for a casino in Vegas where
there are multiple
lists for croupiers to avoid them pushing the wheel on the same roulette
table <vbg, it's on her download page


Peo


"Dave Peterson" wrote in message
...
Do the first cell following Debra's instructions.

Then do the second cell following the same instructions.

I don't understand why that wouldn't work.

Michael wrote:

Hey Dave,

Thanks for your reply. I have already looked at that particular example
posted on the website. However, it does not say anything about muliple
lists
that depends on the first selection. The examples on the website talks
mainly about just one list dependent on the first choice, using the
indirect
function in data validation.

I have two different cells that are dependent on what is selected in the
first cell...I hope i am being clear.

"Dave Peterson" wrote:

Debra Dalgleish knows how:
http://contextures.com/xlDataVal02.html

Michael wrote:

Hi all,

Does anyone know how to create two list in different cells based on
the
selection of the first list?

For example, i have one drop down list with these items: A, B ,C, D.

If 'A' is chosen, then i have two seperate cells that are dependent
on the
selection of 'A' with their own list of values. 'A' has values of
"A1, A2."

And 'A1' has list of 1,2,3,4
'A2' has list of 5,6,7,8.

I hope someone can help. Thanks in advance.

--

Dave Peterson


--

Dave Peterson





  #6   Report Post  
Posted to microsoft.public.excel.misc
Michael
 
Posts: n/a
Default data validation--multiple dependent list

Dave,

Thanks again for your reply.

Will you give me an example? I don't think you can use the same name for
two different lists. This is the reason i think it wouldn't work.

Appreciate your help.

"Dave Peterson" wrote:

Do the first cell following Debra's instructions.

Then do the second cell following the same instructions.

I don't understand why that wouldn't work.

Michael wrote:

Hey Dave,

Thanks for your reply. I have already looked at that particular example
posted on the website. However, it does not say anything about muliple lists
that depends on the first selection. The examples on the website talks
mainly about just one list dependent on the first choice, using the indirect
function in data validation.

I have two different cells that are dependent on what is selected in the
first cell...I hope i am being clear.

"Dave Peterson" wrote:

Debra Dalgleish knows how:
http://contextures.com/xlDataVal02.html

Michael wrote:

Hi all,

Does anyone know how to create two list in different cells based on the
selection of the first list?

For example, i have one drop down list with these items: A, B ,C, D.

If 'A' is chosen, then i have two seperate cells that are dependent on the
selection of 'A' with their own list of values. 'A' has values of "A1, A2."

And 'A1' has list of 1,2,3,4
'A2' has list of 5,6,7,8.

I hope someone can help. Thanks in advance.

--

Dave Peterson


--

Dave Peterson

  #7   Report Post  
Posted to microsoft.public.excel.misc
Michael
 
Posts: n/a
Default data validation--multiple dependent list

Hi Peo,

Do you have a link? Thanks for your help.

"Peo Sjoblom" wrote:

I believe Debra posted a sample file recently for a casino in Vegas where
there are multiple
lists for croupiers to avoid them pushing the wheel on the same roulette
table <vbg, it's on her download page


Peo


"Dave Peterson" wrote in message
...
Do the first cell following Debra's instructions.

Then do the second cell following the same instructions.

I don't understand why that wouldn't work.

Michael wrote:

Hey Dave,

Thanks for your reply. I have already looked at that particular example
posted on the website. However, it does not say anything about muliple
lists
that depends on the first selection. The examples on the website talks
mainly about just one list dependent on the first choice, using the
indirect
function in data validation.

I have two different cells that are dependent on what is selected in the
first cell...I hope i am being clear.

"Dave Peterson" wrote:

Debra Dalgleish knows how:
http://contextures.com/xlDataVal02.html

Michael wrote:

Hi all,

Does anyone know how to create two list in different cells based on
the
selection of the first list?

For example, i have one drop down list with these items: A, B ,C, D.

If 'A' is chosen, then i have two seperate cells that are dependent
on the
selection of 'A' with their own list of values. 'A' has values of
"A1, A2."

And 'A1' has list of 1,2,3,4
'A2' has list of 5,6,7,8.

I hope someone can help. Thanks in advance.

--

Dave Peterson


--

Dave Peterson




  #8   Report Post  
Posted to microsoft.public.excel.misc
Michael
 
Posts: n/a
Default data validation--multiple dependent list

Dave,

Here is another example. I hope this is clearer.

ie. cell A1 has a data validation list of silver,gold,red,blue.

If cell A1 is "silver", I want an INDIRECT data validation list with
1,2,3,4,5 in cell B1

If cell A1 is "silver", I want an INDIRECT data validation with
Mats,Owen,Joe,Alex,Ed in C1.


"Michael" wrote:

Dave,

Thanks again for your reply.

Will you give me an example? I don't think you can use the same name for
two different lists. This is the reason i think it wouldn't work.

Appreciate your help.

"Dave Peterson" wrote:

Do the first cell following Debra's instructions.

Then do the second cell following the same instructions.

I don't understand why that wouldn't work.

Michael wrote:

Hey Dave,

Thanks for your reply. I have already looked at that particular example
posted on the website. However, it does not say anything about muliple lists
that depends on the first selection. The examples on the website talks
mainly about just one list dependent on the first choice, using the indirect
function in data validation.

I have two different cells that are dependent on what is selected in the
first cell...I hope i am being clear.

"Dave Peterson" wrote:

Debra Dalgleish knows how:
http://contextures.com/xlDataVal02.html

Michael wrote:

Hi all,

Does anyone know how to create two list in different cells based on the
selection of the first list?

For example, i have one drop down list with these items: A, B ,C, D.

If 'A' is chosen, then i have two seperate cells that are dependent on the
selection of 'A' with their own list of values. 'A' has values of "A1, A2."

And 'A1' has list of 1,2,3,4
'A2' has list of 5,6,7,8.

I hope someone can help. Thanks in advance.

--

Dave Peterson


--

Dave Peterson

  #9   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default data validation--multiple dependent list

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

the top one


Peo


"Michael" wrote in message
...
Hi Peo,

Do you have a link? Thanks for your help.

"Peo Sjoblom" wrote:

I believe Debra posted a sample file recently for a casino in Vegas where
there are multiple
lists for croupiers to avoid them pushing the wheel on the same roulette
table <vbg, it's on her download page


Peo


"Dave Peterson" wrote in message
...
Do the first cell following Debra's instructions.

Then do the second cell following the same instructions.

I don't understand why that wouldn't work.

Michael wrote:

Hey Dave,

Thanks for your reply. I have already looked at that particular
example
posted on the website. However, it does not say anything about
muliple
lists
that depends on the first selection. The examples on the website
talks
mainly about just one list dependent on the first choice, using the
indirect
function in data validation.

I have two different cells that are dependent on what is selected in
the
first cell...I hope i am being clear.

"Dave Peterson" wrote:

Debra Dalgleish knows how:
http://contextures.com/xlDataVal02.html

Michael wrote:

Hi all,

Does anyone know how to create two list in different cells based
on
the
selection of the first list?

For example, i have one drop down list with these items: A, B ,C,
D.

If 'A' is chosen, then i have two seperate cells that are
dependent
on the
selection of 'A' with their own list of values. 'A' has values of
"A1, A2."

And 'A1' has list of 1,2,3,4
'A2' has list of 5,6,7,8.

I hope someone can help. Thanks in advance.

--

Dave Peterson


--

Dave Peterson






  #10   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default data validation--multiple dependent list

I created a list and named it Colors.

I used that for my data|validation list for A1.

I created a list called "Silver_Numbers" (1,2,3,4,5)
and used this for the Data|Validation list in B1:
=INDIRECT(A1&"_Numbers")

I created a list called "Silver_Names" (mats, owen, ..., Ed)
and used this for the Data|Validation list in c1:
=INDIRECT(A1&"_Names")

Each of these cells (B1 and C1) are only dependent on the value in A1.




Michael wrote:

Dave,

Here is another example. I hope this is clearer.

ie. cell A1 has a data validation list of silver,gold,red,blue.

If cell A1 is "silver", I want an INDIRECT data validation list with
1,2,3,4,5 in cell B1

If cell A1 is "silver", I want an INDIRECT data validation with
Mats,Owen,Joe,Alex,Ed in C1.

"Michael" wrote:

Dave,

Thanks again for your reply.

Will you give me an example? I don't think you can use the same name for
two different lists. This is the reason i think it wouldn't work.

Appreciate your help.

"Dave Peterson" wrote:

Do the first cell following Debra's instructions.

Then do the second cell following the same instructions.

I don't understand why that wouldn't work.

Michael wrote:

Hey Dave,

Thanks for your reply. I have already looked at that particular example
posted on the website. However, it does not say anything about muliple lists
that depends on the first selection. The examples on the website talks
mainly about just one list dependent on the first choice, using the indirect
function in data validation.

I have two different cells that are dependent on what is selected in the
first cell...I hope i am being clear.

"Dave Peterson" wrote:

Debra Dalgleish knows how:
http://contextures.com/xlDataVal02.html

Michael wrote:

Hi all,

Does anyone know how to create two list in different cells based on the
selection of the first list?

For example, i have one drop down list with these items: A, B ,C, D.

If 'A' is chosen, then i have two seperate cells that are dependent on the
selection of 'A' with their own list of values. 'A' has values of "A1, A2."

And 'A1' has list of 1,2,3,4
'A2' has list of 5,6,7,8.

I hope someone can help. Thanks in advance.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
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
update data validation list with new entries?? cjtj4700 Excel Discussion (Misc queries) 10 December 12th 05 02:00 AM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Data Validation lists - entering value not in list rgarber50 Excel Discussion (Misc queries) 3 July 19th 05 08:35 PM
Extracting/look up data from a list and select multiple instances Candice H. Excel Worksheet Functions 4 April 29th 05 04:38 PM
Multiple Data Validation Criterias MCorrea Excel Worksheet Functions 4 January 20th 05 08:17 PM


All times are GMT +1. The time now is 07:26 PM.

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

About Us

"It's about Microsoft Excel"