a fantastic example of using data validation drop-down lists combined with dynamic named ranges to create Individuals lists conveniently editable.
For starters, each of the down below templates can be found in Excel https://umaracmw629895.like-blogs.com/28039185/invitation-template-options