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