Then, use the named range as the source reference for the dropdown. As long as the Scope setting is the entire workbook, everything will update as expected, even though the list is on another sheet.

How to Create a New Workbook in Excel. In Microsoft Excel, a program packaged with Microsoft Office, you can create databases of information and then make calculations, graphs and charts based on ...

How Do I Reference a Cell in Another Worksheet in Excel?. Learning to use Excel worksheets like relational databases can help you save time, eliminating duplication when managing large projects.