Auto-complete - dynamic suggestion from a list

Hi all,

I would like to ask if someone can assist me with the below.

I have an excel file with 2 tabs: 'Sheet 1' and 'Sheet 2'

On Sheet 2 there is a list on column A

I would like that when a user types something on sheet 1 excel will give an auto-complete suggestion (dynamic- similar to a web browser) suggestion which picks from Sheet 2.

Would this be possible?

Thanks a lot for your help


Thanks and Regards

Keibri