Fast Tip Friday – Create Dropdown List From Another Workbook

This fast tip demonstrates how to create a dropdown list in an Excel workbook that pulls in values from a list in another workbook.

In another Fast Tip Friday, I demonstrated how to create a dropdown list from another worksheet.

Download Sample Files


  1. Very good Amy, showing off some of the more advanced database like (or database-lite) features of Excel.

Leave a Reply

Your email address will not be published.