Aug 28 2020 04:40 AM
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