Data Validation Question

[Karl]

I have a list of equipment that is Type,Make,Model,
Height,weight,Lenth,Depth etc

What I would like to do is have combo boxes (3) starting with Type - you
pick the type you want the in the next combo it filters the list so just the
Makes with that type available are in that combo - pick your make and the
third combo is just the model numbers of the type and make

I can then use vlookup to add in the height etc

The big list is on a different worksheet

any easy ways to do this without VB or guidance on the VB way if that is the
only way would be great

 

[Debra Dalgleish]

You can create dependent data validation lists. There are instructions here:

http://www.contextures.com/xlDataVal02.html

The source list can be on a different sheet, if the range is named:

http://www.contextures.com/xlNames01.html