Hi,

I have 2 cols (Ex : State & City).
X state has 10 cities and Y state has 15 cities and Z state has .......

I want to design the template using the data validations (Drop down). If i
select X state in the 1st col it shud have the details of the X state in the
2nd col, means it shud dispaly only the 10 cities corresponding to the X
state in the 2nd col drop down. Then we can select any one city out of 10
from the drop down available in the 2nd col.

Can any one help me to design this template?

Thanks in Advance!!!!!!

-chr

See

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

In article ,
Christopher Naveen
wrote:

Hi,

I have 2 cols (Ex : State & City).
X state has 10 cities and Y state has 15 cities and Z state has .......

I want to design the template using the data validations (Drop down). If i
select X state in the 1st col it shud have the details of the X state in the
2nd col, means it shud dispaly only the 10 cities corresponding to the X
state in the 2nd col drop down. Then we can select any one city out of 10
from the drop down available in the 2nd col.

Can any one help me to design this template?

Thanks in Advance!!!!!!

-chr