creating drop down list based on prev drop down selection

[Simmerin]

What im trying to do is set up a contact sheet in the back of a workbook
company, contact name, ph, fax, cell, email

and then on our proposal page i want a drop down that allows you to select the company(with no duplicates)
and based on that selection it will give you a drop down for the contacts that are from that company, the vlookup portion following that is easy enough for the contact info.

I just cant figure out how to make the company drop down create the contact drop down

 

[Akashwani]

Hi,

Welcome to MrExcel.

Take a look here....

http://www.youtube.com/watch?v=Los7Nb6Skdk

http://www.youtube.com/user/ExcelIsFun#p/search/1/lMLBhz8ouZk

Good luck.

Ak

 

[Simmerin]

ok so i think i figured out how to do the dependency thing on my own. i still dont know how to get my first drop down to omit spaces.

Thanks for the youtube videos btw, they were my inspiration