Does someone can hlelp me to create a drop down list that works as follows:

1. It neeeds to be able to refer a diffrerent workbook for data.

2. As I am typing letteres, the possible options are to appear in the drop-down list.