In column A of sheet1 I have a list of all the customers, in shhet2 I have an invoices template. I want that in sheet2 after typing the first words it appears the complete name.
Per example if I type:
Pe
it appears
Peter White
Peltree Jhon
and I chosee the one I want.
Per example if I type:
Pe
it appears
Peter White
Peltree Jhon
and I chosee the one I want.