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

%3CLINGO-SUB%20id%3D%22lingo-sub-1618437%22%20slang%3D%22en-US%22%3EData%20entry%20cell%20in%20sheet%201%2C%20autocomplete%20from%20a%20table%20in%20sheet%202%2C%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1618437%22%20slang%3D%22en-US%22%3E%3CP%3EG'Day%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20just%20making%20a%20daily%20bookkeeping%20excel%20sheet%20to%20serve%20instead%20of%20paper%20BK%20version%2C%20all%20i%20want%20is%20to%20write%20in%20any%20cell%20in%20column%20B%20and%20while%20you%20typing%2C%20the%20names%20narrows%20down%20and%20you%20select%20the%20name%20you%20are%20doing%20his%2Fher%20bookkeeping%20transaction.%3C%2FP%3E%3CP%3Ewhy%20it%20is%20important%2C%20the%20accuracy%20with%20the%20other%20formulas%20is%20important%20as%20a%20space%20at%20the%20end%20of%20the%20name%20disables%20the%20other%20formulas%20to%20run%2C%20which%20means%20more%20typo%20and%20inaccuracy.%3C%2FP%3E%3CP%3ETh%20eneclosed%20file%2C%20i%20want%20to%20write%20in%20B2%20and%20autocomplte%20assist%20from%20the%20table%2Fcolumn%20in%20Sheet%202%2FColumn%20A%2C%20or%20even%20write%20and%20select%20to%20be%20more%20precise%20to%20let%20the%20other%20formulas%20work%20as%20well%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1618437%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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