Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Lists | Excel Discussion (Misc queries) | |||
Custom Lists | Excel Discussion (Misc queries) | |||
Re-Using Custom Lists | Excel Discussion (Misc queries) | |||
custom lists and custom formulas? | Excel Discussion (Misc queries) | |||
Custom Lists | Excel Discussion (Misc queries) |