When working with multiple sheets in an Excel workbook, you may need to reference data from one sheet to another for calculations, analysis, or to keep your workbook organized. Here are a couple ...

You can reference a list on another sheet, but it takes a bit more work. In this tutorial, I’ll show you how to populate a dropdown with data on another sheet.