List Question

**trader2** · 01-28-2009, 09:13 AM

I am working on a project and have a question.

I am trying to create an interactive/user friendly sheet in order to determine information on forage species for cattle.

My goal is for there to be a drop down list that contains the information in the "Forage Species" column. After selecting the particular species the corresponding information will also be displayed. I need to be able to select multiple species.

If at all possible, the easiest solution would be the best. I have to teach the process to several of my coworkers...some of which would be very confused with VBA/macro's etc.

I appreciate the help, in advance!

**NBVC** · 01-28-2009, 09:20 AM

So you are trying to create a separate sheet that the user selects items from drop down list containing those Species in Sheet1?

**royUK** · 01-28-2009, 09:24 AM

You can use Dynamic Named Ranges, Data Validation & VLOOKUP.

For explanations of Data Validation & VLOOKUP look at

http://www.excel-it.com/data_validation.htm

http://www.excel-it.com/excel_functions.htm

**trader2** · 01-28-2009, 09:25 AM

Sort of. It doesn't necessarily have to be a seperate sheet.

short scenario:
The species are listed on sheet one, this is the user friendly version. They choose whatever species they need for their project. The results that they choose will eventually be displayed on a nice, tidy, and printable format on a seperate sheet.

So the data table, and the cell with the listing feature, can be on the same sheet.

I hope my explanation is not too confusing.