Excel 2016 how to autofill data entries based on a reference sheet

Copper Contributor

I have a workbook where I have several rows with companies information, one of them the correct name of the company. 

When a different user add new data related to currently listed companies, I need that if he or she starts to write name or acronyms it appear the info that has already been (Autofill) about this company.

How may I do that?

Any suggestion will be welcome,

Kind regards,

Bet

0 Replies