Data entry cell in sheet 1, autocomplete from a table in sheet 2, the same workbook

Copper Contributor

G'Day everyone,

 

Am just making a daily bookkeeping excel sheet to serve instead of paper BK version, all i want is to write in any cell in column B and while you typing, the names narrows down and you select the name you are doing his/her bookkeeping transaction.

why it is important, the accuracy with the other formulas is important as a space at the end of the name disables the other formulas to run, which means more typo and inaccuracy.

Th eneclosed file, i want to write in B2 and autocomplte assist from the table/column in Sheet 2/Column A, or even write and select to be more precise to let the other formulas work as well

0 Replies