Drop Down List Pulling From Range From Different Workbook

[bamaisgreat]

Is there a simple way to have dropdown look to a range in a separate workbook?

 

[James006]

Hi,

Are you dealing with Opened ... or Closed workbooks ?

 

[bamaisgreat]

I need the drop down list pull from a range in a closed workbook