Can excel auto suggest from other workbook tab?

[Harry0]

To suggest or auto complete.
If sheet1 has a list of names and in sheet2 you press a letter to have it suggest from that row?

One way to do this is if you are on the workbook sheet right under it but not on another workbook or column.

For example if sheet1 has
Apple
Apricot
Banana
And sheet2 you type A for it to show the apple and apricot for a suggestion.

It only works if you type at the sheet1 column that has the words and no place else.
Thanks

 

[wudixin96]

via VBA ,needs ActiveX Controls(TextBox/ListBox)

 

[Harry0]

So in simple terms to do it simply the answer is NO.
I guess I have to use tricks to do it to move an entire list on the other workbook and hide it and then would have the option.