I am working on building a spreadsheet which populates values in cells based
on values in previous cells. All of this is in drop down lists (data
validation list) or using a combo box.
For Example:
if I enter Automobile in A2, I want B2 to be restricted to Ford, GM, BMW,
etc.
if I enter Airline in A2, I want B2 to only show Delta, Northwest, etc.
And so on....
I also want to copy these lists through out the sheet (row 2 - row 100).
I have got to the point where I am using a combo box for the values in A2
but I can not get over the hump to restrict values in B2 to certain values
(Ford, Delta, etc.) based on what was input in A2.

Not sure if that makes sense, but can anyone help? Thanks in advance.