• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dependent dropdown list with subheader categories


New Member
Hello everybody! This is my first time posting a thread and I really hope someone here can help me quick enough.

I have the following "table" (in quotes bc I couldn't format as an actual Excel table) that brings 3 identical subheaders categories (ADDRESS, EMPLOYEES and EMPLOEMAILS) to each header (the Company).

I need to create three cells with dropdown lists for each subheader category based on the main dropdown list where the user chooses the Company.

Please note that Row 1 brings the headers, Row 2 the subheaders and Raws 3 and 4 the data collected. Also please note that there will be more 20 companies to be added in the table.

I hope I was able to express my challenge well.

Thank you very much if you read this far.



Last edited:


Excel Ninja
As You are a new member, You could reread Forum Rules
especially part
How to get the Best Results at Chandoo.org
and You'll remember that ... ... Your sample file is missing
as well as You have tried to use 'Search'-option to find similar threads.


Excel Ninja
How possible that You didn't know?
In the main page is very clear text like
New Users - Please Start Here
of course, You have started from there.
There can also find:
if you have cross-posted and get an Solution elsewhere,
have the courtesy of posting the Solution here
so other readers can learn from the answer also,
as well as
stopping people wasting their time on your answered question.
( Black has done )