Connecting a drop down list to a database
Connecting a drop down list to a database
(OP)
Hi,
I have made a small database of different material types in excel. First column contains the name of the material, and the other columns are material properties.
I would like to make a drop-down list where I can choose a material and have excel automatically give the material properties in one row.
Any tips are greatly appreciated!
I have made a small database of different material types in excel. First column contains the name of the material, and the other columns are material properties.
I would like to make a drop-down list where I can choose a material and have excel automatically give the material properties in one row.
Any tips are greatly appreciated!





RE: Connecting a drop down list to a database
RE: Connecting a drop down list to a database
I have not used AutoFilter before, but a quick look at it tells me that it is not what I'm looking for.
I would like to have the small database on a seperate worksheet, and have the drop-down on another sheet.
I do not think this can be acheived using AutoFilter.
Thanks
RE: Connecting a drop down list to a database
RE: Connecting a drop down list to a database
that looks great! Is it possible to use a drop down, instead of the thing you use?
If not, this is still great.
Thanks!
RE: Connecting a drop down list to a database
RE: Connecting a drop down list to a database
If you right click on the "List Box" in Sheet1 you can see the properties for an example.
"Form Controls" offer a few different options and I think a drop down box is one.
RE: Connecting a drop down list to a database
RE: Connecting a drop down list to a database
Select Range where you want list of values to appear (input cells).
Data / Validation... Allow: List. Source: =Listname
Turn on in-cell dropdown for the dropdown menu you want.
Turn off ignore blanks and it will not allow any entries other than the ones in the list (which will appear in dropdown)
Example attached created in 2 minutes.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Connecting a drop down list to a database
RE: Connecting a drop down list to a database
Thank you very much