Data Validation Question

  • Thread starter Thread starter kaddrison
  • Start date Start date
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
 
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
(e-mail address removed)
 
Back
Top