In Microsoft Excel 2016, can I create a dropdown list in one workbook with the values from a column in a different workbook?
<p>I'm using Microsoft Excel 2016 and I have a workbook called "ProjectList.xlsx" that has a single column list of projects. What I want to do is that in another workbook, say "Project Status Tracker.xlsx", I'd like to have column A be a dropdown range, except that I want the values in that dropdown come from the "ProjectList.xlsx" workbook. Is this possible?</p>

<p>Thank you,
Sean</p>