Adding new species to dynamic named lists

Hi, hoping someone on here is able to help me?

I have a macro which enters species level data into an excel spreadsheet. The user selects the family from a drop down list, and then each species within that family (to avoid selection of species in other families, and to make selection quicker). This species data is stored in a separate sheet with named range dynamic lists.

The problem I have is adding new species to the current lists when we observe new species. I want to have a second macro within the data entry form where users can add a new species to the list, but the list needs to be selected based on the list name (which is the family name).

How can I tell the macro to "lookup" the family name in the range of lists, and then add the new species name to the bottom of that list?

thanks all! looking forward to your answers

Hi,

Thanks for this, have attached the file here, currently all species info is added onto the bottom of the reference list (which is needed for later analysis) but I also want to add only the "common name" to the relevant family species list in the 'Species' sheet, using the English family name to find the relevant list.

thanks

Hi, Thanks for this, it is great to be able to see how to make the macro much more simplified and neat. I still need to be able to add the common name of the species to the named range in the species worksheet. For example, If I add Longnose Filefish, I need just this name added onto the end of the Filefish list in the "Species" worksheet.

Thanks again for all your help so far.

Thank you! This is just what I needed! Wonderful!