a fantastic example of using knowledge validation drop-down lists combined with dynamic named ranges to help make All those lists simply editable.
This template is like a report card and can be used to keep an eye on https://barrybjfo713419.blogozz.com/27786837/new-step-by-step-map-for-invitation-template