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!
4 freelancers are bidding on average $28 for this job
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.