creating drop down list based on prev drop down selection

Simmerin

New Member
Joined
Jun 24, 2011
Messages
20
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
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Simmerin

New Member
Joined
Jun 24, 2011
Messages
20
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 :)
 

Forum statistics

Threads
1,136,863
Messages
5,678,202
Members
419,750
Latest member
crp

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top