Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List
Hey guys,
I'll try to explain this as best i can...i'm creating a (I'm using this term loosely) "form" for my sales guys to fill out. I have three fields for them to fill out and i want to do a drop down choice for them on each one. However, I want the second set of options to be based off of thier answer to their first one, and the third set of options to be based off of their second one... EX:Each choice is a drop down choice: Question 1: Type of item: Ball, Shoes, Shorts....let's assume they choose "Ball" Question 2: Type: Soccer, Baseball, Basketball,...let's say they choose "Soccer" Question 3: Brand: Nike, Adidas, Fila See how each question builds off each other? Is there a way to align my "list" in the background so the drop down choices will know what answer goes with what? I'm looking forward to your answer!! Thanks again!!! -JC |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List
See:
http://www.contextures.com/xlDataVal02.html -- Gary''s Student - gsnu200735 "JC" wrote: Hey guys, I'll try to explain this as best i can...i'm creating a (I'm using this term loosely) "form" for my sales guys to fill out. I have three fields for them to fill out and i want to do a drop down choice for them on each one. However, I want the second set of options to be based off of thier answer to their first one, and the third set of options to be based off of their second one... EX:Each choice is a drop down choice: Question 1: Type of item: Ball, Shoes, Shorts....let's assume they choose "Ball" Question 2: Type: Soccer, Baseball, Basketball,...let's say they choose "Soccer" Question 3: Brand: Nike, Adidas, Fila See how each question builds off each other? Is there a way to align my "list" in the background so the drop down choices will know what answer goes with what? I'm looking forward to your answer!! Thanks again!!! -JC |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List
Gary,
It worked!! Thanks again for your help!! You've been extremely helpful today!!! "Gary''s Student" wrote: See: http://www.contextures.com/xlDataVal02.html -- Gary''s Student - gsnu200735 "JC" wrote: Hey guys, I'll try to explain this as best i can...i'm creating a (I'm using this term loosely) "form" for my sales guys to fill out. I have three fields for them to fill out and i want to do a drop down choice for them on each one. However, I want the second set of options to be based off of thier answer to their first one, and the third set of options to be based off of their second one... EX:Each choice is a drop down choice: Question 1: Type of item: Ball, Shoes, Shorts....let's assume they choose "Ball" Question 2: Type: Soccer, Baseball, Basketball,...let's say they choose "Soccer" Question 3: Brand: Nike, Adidas, Fila See how each question builds off each other? Is there a way to align my "list" in the background so the drop down choices will know what answer goes with what? I'm looking forward to your answer!! Thanks again!!! -JC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
sort list of players by team from player list on separate sheet | Excel Worksheet Functions |