I'm looking for an Excel developer to refine some fairly basic data entry sheets that biologists will use to create lists of species (plants and animals) and add common names to them. No number processing at all. Just setting up some auto-complete and value lists for terms that have controlled vocabularies.
I have a spreadsheet with a couple of data entry sheets. ? A primary data entry sheet is used to create a basic list of animal and plant species. ? A second sheet is used to catalog different names for the plants and animals, in different languages. ? The two sheets have a basic 1:M relationship. ? I want the user entering names in the second sheet to select from a list of names that were created in the first sheet to maintain relational integrity.
I also have a series of columns containing controlled lists of terms. ? I want these all listed on a final and non-editable sheet. ? When a user enters data in one of the two editable sheets, ? the relevant values will be access from the controlled list of terms and available either as a pulldown list or an autocomplete list based on those controlled vocabulary.
## Deliverables
I have a sample data file and a requirements document that provides additional details. ? See attached.