Best in Excel?
 

I'm looking to create a series of "and then" statements where your answer to
question 1, for example, will reveal options in question 2 based on your
answer.

A simple example:
1. What state do you live in? (Drop down list of the states)
2. Which parish/county/region do you live in? (If they choose Michigan, a
list of Michgian's counties would appear).
3. Which city/town/village do you live in? (the cities withing that county
would then appear in a drop down menu)?

Is Excel the best place to build this? And what would help me get started?

Best in Excel?
 

Debra Dalgliesh has an excelent tutorial on just this, try the link

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

Regards
Peter Atherton

"Zack" wrote:

I'm looking to create a series of "and then" statements where your answer to
question 1, for example, will reveal options in question 2 based on your
answer.

A simple example:
1. What state do you live in? (Drop down list of the states)
2. Which parish/county/region do you live in? (If they choose Michigan, a
list of Michgian's counties would appear).
3. Which city/town/village do you live in? (the cities withing that county
would then appear in a drop down menu)?

Is Excel the best place to build this? And what would help me get started?