I have to admit, I don't really know what I'm doing on this. I showed my boss something I have been working on and he liked it, but he wants something different. Right now I'm using data validation in several cells in a column. Through the vlookup comand, depending on what is chosen, the coresponding data is shown.
So let's say my current setup is model#, description, and last manufacturer. The model# cells contain the data validation and once a choice is made the description and manufacterer is listed also. He wants to have a list in the other areas where he could choose which manufacturer he wants to use or what the decription would be. This would obviously limit the choices for the other fields. If I chose Honda as a manufacturer, I would want to see things like civic, accord, s2000, not viper, focus, or camaro. Maybe I'm not thinking at this hard enough, or am over thinking the issue, but I don't even know where to begin on this. is data validation still the best choice, what about ActiveX controls like combo boxes. On top of that, the lists get be dynamic! Any suggestions or help would be appreaciated greatly on my part.