Display rows based on criteria

  • Thread starter Thread starter Holly
  • Start date Start date
H

Holly

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.
 
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?
 
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!
==============================================


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?
 
Back
Top