Data Validation Question

K

kaddrison

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 s
just the
Makes with that type available are in that combo - pick your make an
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 tha
is the
only way would be grea
 
M

Mark

Hi,
if no one responds to your request, send the workbook, or
a dummmy workbook, to me with all the info as stated here
and I will write a mini-program for you - yes, for free
(till it gets boring).

I prefer to use a userform with combos rather than on
sheet combos as they are prone to crash and burn. I can
also do anything else that requires an ease of use method.


see my handiwork at:
http://www.geocities.com/excelmarksway
http://au.geocities.com/excelmarksway

please allow 2 to 3 days for a possible result
- -Mark
[email protected]
 
Top