Drop Down List

[rockyw]

If I want to have a dropdown list and have the names on another workbook can I just enter the name in source? I tried (H&K Summary Charts 2019 "Data Feed"( N2:N4) ) but it did not work. What am I missing or will this not work? Thanks

 

[James006]

Hello,

Are you keeping both files opened ... or not ...?

 

[rockyw]

I didn't want to keep both open. I seen after I posted that was the only way it would work, is that true. Thanks

 

[James006]

You are welcome ...