Hi

I have a list of data.
Column A is the Subject and then there is say 10 columns with specific data
relevant to that Subject.

I have all the Subjects from Column A in a drop down Combo box on ROW 1.
What I need to do is display in say ROW 2 the data that is on the entire row
that matches what is chosen from the Combo box.

so for example.
The subject is car manufacturer(Ford, Vauxhall, Volkswagon)
The rows would contain each model.
When I chose the manufacturer it would tell me in ROW 2 the Models
availalable.

Hope this makes sense

SlicK