Autocomplete using a defined range

[jonjonjonjon]

Hi,

I was wondering if there is a way to use excel's autocomplete function without it having to be directly under the source data, in the same column, and sheet?

For example, the source data is in sheet 2 and i am workings in sheet 1. So in sheet 1, if start typing the first few letters it will show me the autocomplete suggestion in relation to the source data in sheet 2.

Many thanks