Simple EXCEL create dependent drop down lists

Simple project. I have a master data list with 13 columns.

I would like to create a tab with several drop down lists that RESTRICT the selection to what is on the spreadsheet.

When you filter each item, it will provide you with a list of items that are possible for this selection.

Here is an example:

1) Column a shows PHYLUM (there are only 22 options in this list)

3) Column c shows CLASS (there are only 43 options in this list, however if someone selects a specific PHYLUM, the CLASS dropdown should only show the supported options based on the filtered list.

Attached is a sample spreadsheet to make it more clear what the end result should look like.


Create 13 drop down fields and make them DEPENDENT on the source list that I will send to you. It has about 3000 records.

Basically, if someone selects something in DROPDOWN#1, it should determine what their options are in DROPDOWN#2 and so far. (data validation)

Please only apply if you understand Excel very well. Thank you all!

Taidot: Excel, Visual Basic, Visual Basic for Apps

Näytä lisää: dependent drop list php mysql dependent drop lists, excel dependant drop lists, create cascading drop lists ajax asp net, city drop lists, php populate drop lists database, excel simple macro data comparing copy, excel simple, create cms simple templates, simple elegant look websites, excel simple programs

Tietoa työnantajasta:
( 54 arvostelua ) Victoria, Canada

Projektin tunnus: #8672410

Myönnetty käyttäjälle:


Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Lisää

$30 CAD 1 päivässä
(178 Arvostelua)

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before Lisää

$26 CAD 1 päivässä
(51 arvostelua)

This is quite a simple task, please award the project to get it done. Experienced programmer with more than 10 years of programming experience here.

$30 CAD 1 päivässä
(12 arvostelua)

A proposal has not yet been provided

$25 CAD 1 päivässä
(0 arvostelua)