Filter-Filter
 

I have created a List with data, for example:

1 Food
1.1 groceries
1.2 meals out
1.3 wine club
2 Household
2.1 maintenance yard and pool
2.2 appliances, furniture, furnishings, suplies
2.3 ...

I have a column for "Areas" which in this example a 1 Food, 2 Household,
and so on and the next column is for "Concepts" which would be: 1.1
groceries, 1.2 meals out and so on. I used Data Validation to select the
choices for Area from a List I set in another tab. Is it possible to, for
example if I choose "1 Food", that my next column where I choose the concepts
only displays me the concepts that belong to 1 Food (1.2, 1.3, ...) instead
of ALL the Concepts from all the Areas?

,thanks.

Filter-Filter
 

Look at this site:

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

where you will find excellent examples of how to create dependent lists.

HTH

"Ed" wrote:

I have created a List with data, for example:

1 Food
1.1 groceries
1.2 meals out
1.3 wine club
2 Household
2.1 maintenance yard and pool
2.2 appliances, furniture, furnishings, suplies
2.3 ...

I have a column for "Areas" which in this example a 1 Food, 2 Household,
and so on and the next column is for "Concepts" which would be: 1.1
groceries, 1.2 meals out and so on. I used Data Validation to select the
choices for Area from a List I set in another tab. Is it possible to, for
example if I choose "1 Food", that my next column where I choose the concepts
only displays me the concepts that belong to 1 Food (1.2, 1.3, ...) instead
of ALL the Concepts from all the Areas?

,thanks.

Filter-Filter
 

Thank you very much, the information was very useful.
, Ed