Data validation & selection

See more:

MS-Excel

Dear All,

I have data in a drop-down list.

When I select an option from the drop-down list entries related to the particular option should be displayed in another column.
When I change an option, entries should be come in other columns related to the next option.

How can I do this?

I can do it for single entry with lookup but what for multiple entries.

Actually, I've workbook, in which I've many sheets, Just Like:

In Sheet2, I've Project Details, and in Sheet1 I've drop down list of Project Names,
I want,
When I select in Sheet1's drop-down list "Project1", all details in the columns of Project should be appear, when I make select another project then details of that project should be appear.

I think I've to write vba script for the above purpose but How can I do this, please tell me.