Working with custom lists
 

Hello,

I have two columns in my worksheet; the first contains text related to
high level categories and the second contains records associated to
these categories. My goal is to view only relevant records in column B
based on the category selected in column A.

For example:

Column A selections might include Aircraft, Automobiles and Bicycles.
When I choose Aircraft in column "A" I would then only be presented
with records relevant to aircraft. When I choose Automobiles in column
"A" I would then only be presented with records relevant to
automobiles, etc.

Any assistance would be greatly appreciated!

Thank you

Working with custom lists
 

napisal(a):
Hello,

I have two columns in my worksheet; the first contains text related to
high level categories and the second contains records associated to
these categories. My goal is to view only relevant records in column B
based on the category selected in column A.

For example:

Column A selections might include Aircraft, Automobiles and Bicycles.
When I choose Aircraft in column "A" I would then only be presented
with records relevant to aircraft. When I choose Automobiles in column
"A" I would then only be presented with records relevant to
automobiles, etc.

Any assistance would be greatly appreciated!

Thank you

i think u should look at
http://www.ozgrid.com/BookExamples/e...k-examples.htm
ch 2 - validation lists
mcg

Working with custom lists
 

You can look at Data=filter=autofilter if your data is laid out as a
database.

If you are talking about data validation dropdowns:

Dependent lists - data validation
http://www.contextures.com/xlDataVal02.html
as Debra Dalgleish's site

--
Regards,
Tom Ogilvy


" wrote:

Hello,

I have two columns in my worksheet; the first contains text related to
high level categories and the second contains records associated to
these categories. My goal is to view only relevant records in column B
based on the category selected in column A.

For example:

Column A selections might include Aircraft, Automobiles and Bicycles.
When I choose Aircraft in column "A" I would then only be presented
with records relevant to aircraft. When I choose Automobiles in column
"A" I would then only be presented with records relevant to
automobiles, etc.

Any assistance would be greatly appreciated!

Thank you