The text/numerics recorded in the first three columns of a worksheet determine the text/numeric content of the fourth column. I would like to know the best way to set up an autocomplete script excel for the fourth column? Thanks.Â
Dear customer,
Auto complete, or Autofill, is a great feature on Microsoft Excel, you can find the Autofill items (days/numbers/months) stored in the program by the manufacturers, or you can make your own Autofill list. You can do this in a few simple ways, but if you are using Microsoft Office 2003, it is different from the 2010 version. In the two links below, you will find the instructions.
https://itstillworks.com/add-names-auto-fill-excel-11415482.html
https://excel.tips.net/T002110_Understanding_AutoComplete.html
Â
So you would want the data from columns 1, 2, and 3, to  determine the result for column 4, and the solution to that is not through an "autocomplete excel script" but an excel formula to concatenate the 3 values. Excel concatenation does not compute numerical or textual values in multiple cells, but position the values of each cell in the specific concatenation formula. So for example, you want values inside A1, B1, and C1 to be in a series "C1 A1 B1" order without typing it on D1, then you would type on D1:
Example
A1Â = "the"
B1Â = "fence"
C1Â = "jump over"
Â
D1Â = "=Concatenate(C1,A1,B1)"
I have provided a screenshot for your reference:
Hi Donna DavisÂ
According to your question this Techyv post "Auto fill / Drag and drop in Microsoft Excel" also provided some solutions which one you can apply to fix this issue too.
