Dynamic dependent data validation list

Hi all,

I got stuck when trying to get a dynamic data validation list who is dependent on another data validation list. I would really appreciate some help here.

I've uploaded a workbook that hopefully illustrates what i am trying to accomplish. In a summary: I have some companies as a header in a couple of columns. Under each company there are contact persons for that company.

I now have a dynamic drop down list with all the companies and need to have a drop down list that is dynamic and will change depending on whats chosen in the drop down list that contains the company names.

/Masun

Hi,

Thanks for answering. I have looked it out. If i understood it correctly you need to make a named range for each of the different drop down lists. That makes it less dynamic in my case since it will not work if any of my colleagues enter a new company and some contact persons for that company. I wish it to work without the colleagues have to define a name...

Hi again,

I have been struggling with this for quite a while now. Do you mean that if a new company in my uploaded file will be added (ie a new column with the company name as header and Contact persons in the same column under the header) that i or my colleagues wont have to make a defined name?

The table feature with all its dynamic wont work for me cause my data is in seperate sheets.

There must be something that i dont understand here, are u able to show me in my uploaded file?

/Masun

Hi,

Thanks for the answer. If i arrange my data like you suggest, i will have some trouble in the drop down list in A22 (the companies), the formula i have will not give me the unique values but all the values in the "company" list. Is there some way to get the unique company names in the dropdown list?