Drop down list from another excel that contains some word in the english language?

Drop down list from another excel that contains some word in the english language?


Hi is it possible to create drop down list that contains some word in the english language? possibly linking to a from another excel the one built into office 2007/10...

I would like to be able to start typing a word in the cell and it starts to show the drop down list of all the matching words as I enter the keys and once I see the correct word I can select it?

HI,


As per My knowledge it is not possible.
But an alternative could be to create a link between the destination workbook with source workbook.
and using the range from local source as input for drop down list.