Hi all,

Is it possible to create a dropdown box linked to a list in another workbook?

I am trying to do this through 'data valadition' ---'list'...but this approach is not working. when I click on 'Source' it does not allow me to change into the other workbook.

it would be great to get ideas and feedback.

Thanks

Nick