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

[email protected] 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

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


"[email protected]" 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
>
>