Drop down lists dependant on previous drop down list

Hi,

Is there any way that I can have drop down lists that are dependant on the previous drop down list?

For example in my sample workbook I have Continents, Countries and then Cities. If Europe was selected in the first drop down list then in the second only the countries in Europe would appear, and then if England was selected in the second list, only the cities in England would be available in the third drop down list.

Thanks,

Alex

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

Please go through this

Originally Posted by akhileshgs

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

Please go through this

Hi, thanks for your reply.

Unfortunately I don't have access to videos where I am at work so I am unable to go through all of this guide. I did stumble across this before but had to try and find another way of understanding a solution to my problem.

I also don't have Microsoft Office at home so that poses another issue for me.

Since you can't view videos at work, then try this link

http://www.excel-easy.com/examples/d...own-lists.html

Originally Posted by pareshj

It is very simple to create dependent drop down list in excel. Check out the below link and follow the steps,

http://snpinfotech.wordpress.com/201...ists-in-excel/

Hi pareshj,

Thanks for your reply, I did manage to sort out a solution a while ago now but thank you all the same! I did actually do it in exactly the same way as your link. Very simple and easy, thanks again!

Thanks for appreciation!!! I am glad that I was able to help you. For any issues related to excel, you can write me