excel auto correct

Occasional Visitor

version for Mac,16.47.1 

I have a list of names on one sheet. I would like to reference those names on another sheet of the same workbook by typing the first 2 letters of the name. Auto correct will reference this but only if the info is in the same column. How can I reference from another sheet/column?

1 Reply
Look into Data Validation as the method, with that full list as the approved list.
https://exceljet.net/excel-data-validation-guide