I have a list of customers, and each customer has a list of their model
names. Eg.
Customer: A, Model: A1, A2, A3..
B, Model: B1, B2, B3...
C, Model: C1, C2, C3....
I want my excel column A to display the list of customer and for me to
choose one (which i know i can do so by "validation", and choose list)
Then i want the column B to display the list of models correspond to the
column A selection. Meaning if i choose customer A from the list, column B
should display the list is B1,B2,B3... then i choose one of them from the
list (like the "validation").
But i dunno how to do so with excel. can any one teach me?

Hi,

Refer to this URL: http://www.contextures.com/xlDataVal02.html

Challa Prabhu

"Jacky" wrote:

I have a list of customers, and each customer has a list of their model
names. Eg.
Customer: A, Model: A1, A2, A3..
B, Model: B1, B2, B3...
C, Model: C1, C2, C3....
I want my excel column A to display the list of customer and for me to
choose one (which i know i can do so by "validation", and choose list)
Then i want the column B to display the list of models correspond to the
column A selection. Meaning if i choose customer A from the list, column B
should display the list is B1,B2,B3... then i choose one of them from the
list (like the "validation").
But i dunno how to do so with excel. can any one teach me?

First of all, i have to thanks Challa for solving my question. Thank you very
much Challa.

But i have 3 questions arrises:
1) When the list is long, the drop down cell only display 8 rows each time,
is there a way i can show more than 8 rows a time at the drop down cell?

2) The text in the drop down cell has a standard form size, i find it too
small. Is there a way i can mke the text to be larger size in the drop down
cell?

3) Suppose my list contents: Alpha, Beta, Cat, Dog, Elephant
When i clip the arrow and drop down cell apprears, if i type "a" can the
list automatically filter and only shows me the matching words (in the drop
down cell) so far?

Thank you very much.

"Jacky" wrote:

I have a list of customers, and each customer has a list of their model
names. Eg.
Customer: A, Model: A1, A2, A3..
B, Model: B1, B2, B3...
C, Model: C1, C2, C3....
I want my excel column A to display the list of customer and for me to
choose one (which i know i can do so by "validation", and choose list)
Then i want the column B to display the list of models correspond to the
column A selection. Meaning if i choose customer A from the list, column B
should display the list is B1,B2,B3... then i choose one of them from the
list (like the "validation").
But i dunno how to do so with excel. can any one teach me?

Hi Jacky

Also on Debra's site, the following answers your first 2 points
http://www.contextures.com/xlDataVal08.html#Font

Using a Combo box can give more than 8 lines, and provide Autocomplete.
Details here
http://www.contextures.com/xlDataVal11.html

There is a workaround for to jump to a certain letter in a data
validation list in an example file I created which Debra has at
http://www.contextures.com/DataValHeadings.zip

--
Regards

Roger Govier


"Jacky" wrote in message
...
First of all, i have to thanks Challa for solving my question. Thank
you very
much Challa.

But i have 3 questions arrises:
1) When the list is long, the drop down cell only display 8 rows each
time,
is there a way i can show more than 8 rows a time at the drop down
cell?

2) The text in the drop down cell has a standard form size, i find it
too
small. Is there a way i can mke the text to be larger size in the drop
down
cell?

3) Suppose my list contents: Alpha, Beta, Cat, Dog, Elephant
When i clip the arrow and drop down cell apprears, if i type "a" can
the
list automatically filter and only shows me the matching words (in the
drop
down cell) so far?

Thank you very much.

"Jacky" wrote:

I have a list of customers, and each customer has a list of their
model
names. Eg.
Customer: A, Model: A1, A2, A3..
B, Model: B1, B2, B3...
C, Model: C1, C2, C3....
I want my excel column A to display the list of customer and for me
to
choose one (which i know i can do so by "validation", and choose
list)
Then i want the column B to display the list of models correspond to
the
column A selection. Meaning if i choose customer A from the list,
column B
should display the list is B1,B2,B3... then i choose one of them from
the
list (like the "validation").
But i dunno how to do so with excel. can any one teach me?