Dependent Drop Down

  • Thread starter Thread starter gibbylinks
  • Start date Start date
G

gibbylinks

Hi,

I want to be able to have a dropdown box with company names in it, and then
another beneath with contacts ONLY from the company selected above.

I'd like to take the information from a seperate sheet called "Contacts" and
in the format

Company1 Company2 Company3
Contact1 Contact1 Contact1
Contact2 Contact2 Contact2
Contact3 Contact3 Contact3

So you would have the company names in A1 -> A999999 and the contacts
underneath each company

Best way to acheive this please
 
Thanks for the help.

Apologies though, I posted in the wrong forum, should have been in excel.
 
Back
Top