Using A Validation List In Another Worksheet Or Workbook
Data validation is an Excel feature that helps users enter data correctly on worksheets. One form of data validation lets you define a source list, elsewhere on the worksheet, of the possible entries for a cell. When a user clicks the cell to enter data, Excel provides a drop-down list of the possible entries. With data validation, users can click a choice from a list you supply, ensuring that only appropriate values are entered.