Create Drop-down List From Other Workbook

Juan,

Regarding your question of creating drop-down list at other workbooks by using the database from different workbook. When the database is revised, the drop-list of all the related workbooks will change accordingly. I had show the ways of doing so.

1. Create drop-down list where the data get from other workbook.

2. Show the Form toolbar.

3. Show Format Control dialog box.
4. Setting the Input range from other workbook.
5. The drop-list down is created after click OK.