Setting up an ‘autocomplete script excel’

Asked By Donna Davis 20 points N/A Posted on - 11/23/2012

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. 

• Status: Open
• Question Views: 851
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Cohen Wible

Go To Solution

Answered By shipley thmcalpine 5 points N/A #137210

Setting up an ‘autocomplete script excel’

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

About shipley thmcalpine

Questions
3

Answers
12

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 11/23/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Cohen Wible 0 points N/A #137211

Setting up an ‘autocomplete script excel’

 

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:

About Cohen Wible

Questions
2

Answers
103

Best Answers
54

• Vote Up 0 Vote Down

• Posted on - 05/11/2013
• Question Category: MS Excel

Answered By Bruce M Toole 20 points N/A #137212

Setting up an ‘autocomplete script excel’

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.

About Bruce M Toole

Questions
5

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/16/2014
• Question Category: MS Excel