Display rows based on criteria

Hello,

I have 2 fields that are populated based on user entry:
1- Age
2- Trip length

Based on the answer to these questions, I would like for
excel to display a subset of rows.
For ex: If I were 70 yrs old taking a trip for 15 days,
then I need to see Option 1 only. Where Option 1 is a
list of questions to answer. But if I was taking a trip
for 30 days, then display Option 2's series of questions.
Presently, Option 1 and 2 are on the same workbook. And
depending on the answers to Option 2, you would
potentially have to answer Option 3 questions.

Thanks!

Select data including headers and do data / Filter / Autofilter, then click on
the dropdowns and knock yourself out with all the fun you're going to have :-)

Bear in mind there is a 'custom' option at the top of the list that you may well
need to use.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Holly" wrote in message
...
Hello,

I have 2 fields that are populated based on user entry:
1- Age
2- Trip length

Based on the answer to these questions, I would like for
excel to display a subset of rows.
For ex: If I were 70 yrs old taking a trip for 15 days,
then I need to see Option 1 only. Where Option 1 is a
list of questions to answer. But if I was taking a trip
for 30 days, then display Option 2's series of questions.
Presently, Option 1 and 2 are on the same workbook. And
depending on the answers to Option 2, you would
potentially have to answer Option 3 questions.

Thanks!



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 28/05/2004

But is there a way so that the filter updates
automatically?
So that if the trip length changes that the Option of
questions would change automatically?


-----Original Message-----
Select data including headers and do data / Filter /
Autofilter, then click on
the dropdowns and knock yourself out with all the fun
you're going to have :-)

Bear in mind there is a 'custom' option at the top of the
list that you may well
need to use.

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------
------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------
------------------



"Holly" wrote in
message
...
Hello,

I have 2 fields that are populated based on user entry:
1- Age
2- Trip length

Based on the answer to these questions, I would like for
excel to display a subset of rows.
For ex: If I were 70 yrs old taking a trip for 15 days,
then I need to see Option 1 only. Where Option 1 is a
list of questions to answer. But if I was taking a trip
for 30 days, then display Option 2's series of
questions.
Presently, Option 1 and 2 are on the same workbook. And
depending on the answers to Option 2, you would
potentially have to answer Option 3 questions.

Thanks!



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date:
28/05/2004


.

You might explore using multiple (dependent) drop-down lists through data
validation.

Debra Dalgleish's web site has extensive help info on creating such
dependant lists.

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Holly" wrote in message
...
But is there a way so that the filter updates
automatically?
So that if the trip length changes that the Option of
questions would change automatically?


-----Original Message-----
Select data including headers and do data / Filter /
Autofilter, then click on
the dropdowns and knock yourself out with all the fun
you're going to have :-)

Bear in mind there is a 'custom' option at the top of the
list that you may well
need to use.

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------
------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------
------------------



"Holly" wrote in
message
...
Hello,

I have 2 fields that are populated based on user entry:
1- Age
2- Trip length

Based on the answer to these questions, I would like for
excel to display a subset of rows.
For ex: If I were 70 yrs old taking a trip for 15 days,
then I need to see Option 1 only. Where Option 1 is a
list of questions to answer. But if I was taking a trip
for 30 days, then display Option 2's series of
questions.
Presently, Option 1 and 2 are on the same workbook. And
depending on the answers to Option 2, you would
potentially have to answer Option 3 questions.

Thanks!



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date:
28/05/2004


.