Excel How-to
Data Validation List from Another Sheet in Excel
Point an Excel or Google Sheets drop-down at a list on another sheet. Use a sheet-qualified range or a named range, and keep the header out of the source.
#named-range
1 tutorial tagged “named-range”.