Excel 2010 - wanting to add another feature to my .xlsm file.
Sheet1 is the draft sheet, sheet2 has a list of names
When entering the draft pick on sheet1, I want it to auto-complete the name from sheet2 into sheet1
ex. Entering Rodg, it would come up with Rodgers, Aaron
I've attached a sample.
Bookmarks