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.

Excel macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you.