I want to know I I can get help with this.


I have about 12 columns and more than 400 rows of information.

My second row is empty and this is were I want to do the following

I know how to make a drop-down list for the firs column. but now I want to when I click on the list and get an name, it
must also show all the info of this name in the rest of the columns.

The name of the first column can also be there more than one. eg.

column A column B column C
Lan 1 new
Lan 2 old
Busres 5 new

So I need it to show in row two when I first click on drop-down list, and choose any of lan it must give me this

Lan 2 old