Double Drop Down List & Corresponding Text Info Disply

[Ritchie Sobell]

I have two drop down lists (created using =INDIRECT() method). This
enables the second drop down list to automatically contain the
corresponding info based on what is chosen in the first list. (E.g.:
If I picked Ford in the first drop down list the second list will
automatically contain all the different Ford model vehicles).
Now, when I pick a specific model from the second drop down list I
want a mechanism to display 10-rows and 4 columns worth of information
on the same worksheet. (This 10-rows and 4-columns of information is
various parts that belong to the specific model of car chosen in the
second drop down list. I.e.: First column has the specific car model,
second the manufacturer part number, third column part details and
forth quantity in hand).
In summary:
First Drop Down --> Pick 'Ford' (from a list of Honda, Ford, BMW etc.)
Second Drop Down --> Pick 'Escort LX' (from a list of Escort,
Explorer, Taurus, etc.)
10-row, 4 columns Part Info:
Model Vehicle Part# Part Description Qty.
============= =============== ================ ====
Escort LX ENG-345-LX-TBEL Timing Belt 5
Escort LX FIL-8790-AA-SOF Oil Filter 1
.....

Data for the 10-row, 4-column section already exists in another
worksheet (in the same workbook) in an Excel tabular format but with
part details of all the different vehicles in the same worksheet.
E.g.:

Escort LX ENG-345-LX-TBEL Timing Belt 5
Escort LX FIL-8790-AA-SOF Oil Filter 1
........
........
........
Civic H1UUU-FG19-SPL Spark Pulg 20
Civic Y8787-FUEF-TYI Fuel Filter 0
........
........
Explorer ......

I know this can be effeciently done in MS Access, but in this
situation it must be done in Excel. Since I'm new to Excel VBA and
Macros, can someone please show me how this can be accomplished?

One other note, when the selection changes in either of the drop down
lists, automatically everything should be reset to blank. (I.e.: After
I picked Escort LX from the second drop down list, now when I go to
the first drop down and pick Honda, then the Parts detail rows and
columns have to clear the Escort LX info from the table till I make a
specific Honda model choice from the second drop down list).

Sorry for the long essay and Thanks in advance to any guidance.

 

[Debra Dalgleish]

There's a sample here that uses data validation and and Advanced filter
to extract data from a table --

http://www.contextures.com/excelfiles.html
Under Filters, look for 'Product List by Category'

You could add code to the manufacturer selection, that clears the
results from the previous filter.