Hi,

I've already created a drop list for each cell in several Columns. Example
for Column A is a list that will show all car brands e.g. Volvo, Toyota,
Honda. Column B will show the whole list of models e.g Carmy, Altis, Civic,
Accord, S40, S60. But I will like to improvise it further by showing only the
models that is applicable to the respective car brands (after selecting it).
e.g. after selecting Volvo, the drop list for model will show only S40 and
S60 instead of the whole list.

Pls teach me how to do it or if it can be done. Thanks!

Try Debra Dalgleish's page at:
http://www.contextures.com/xlDataVal02.html
Excel -- Data Validation -- Create Dependent Lists
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MelvinLim" wrote:
Hi,

I've already created a drop list for each cell in several Columns. Example
for Column A is a list that will show all car brands e.g. Volvo, Toyota,
Honda. Column B will show the whole list of models e.g Carmy, Altis, Civic,
Accord, S40, S60. But I will like to improvise it further by showing only the
models that is applicable to the respective car brands (after selecting it).
e.g. after selecting Volvo, the drop list for model will show only S40 and
S60 instead of the whole list.

Pls teach me how to do it or if it can be done. Thanks!