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.