Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation Selection
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation Selection
Make a Google search with keywords "dynamic validation list"! You'll find
several pages teaching this tecnique, e.g. http://www.contextures.com/xlDataVal02.html Regards, Stefi gibbylinks ezt *rta: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation Selection
"Stefi" wrote: Make a Google search with keywords "dynamic validation list"! You'll find several pages teaching this tecnique, e.g. http://www.contextures.com/xlDataVal02.html Regards, Stefi gibbylinks ezt *rta: 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 reply stefi. I was hoping there was another way to do this. I'd like to able to add companies and sort them alphabetically, and put new contacts in without having add or redefine ranges each time. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
Data Validation with selection | New Users to Excel | |||
validation selection | Excel Worksheet Functions | |||
validation list - filter based on selection | Excel Worksheet Functions | |||
How can you jump to a selection in a validation drop-down? | Excel Worksheet Functions |