Dependent Drop Down

[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

 

[Paul M]

Hi
Here is a script for a chained menu
http://www.dynamicdrive.com/dynamicindex1/chainedmenu/index.htm

Hope this helps
Paul M

 

[Kathleen Anderson]

You can also create one using an Access Database:
http://www.spiderwebwoman.com/tutorials/jumpmenu.htm

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[gibbylinks]

Thanks for the help.

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