Main Area and Open Discussion > General Software Discussion

autofill in EXCEL

(1/4) > >>

kalos:
hello

I would like to do this in MS EXCEL:

when I type a specific "word" in a column named "column" to automatically write in the same line: "word1" in "column1", "word2" in "column2" etc (in other words to autofill the other cells of the line with specific data for each collumn)

can you tell me please how to do this?

thanks

David1904:
I'm assuming you already have a table of data somewhere where "word", "word1", "word2" etc, are already existing as rows (or columns), and that what you want to do is to have the related items filled in whenever you choose a particular instance of "word".
If this is the case, then using VLOOKUP or HLOOKUP would probably be you answer.

If this is not the case you may need to supply more details so we can get a better understanding of your requirements.

David

kalos:

I'm assuming you already have a table of data somewhere where "word", "word1", "word2" etc, are already existing as rows (or columns),
-David1904 (April 30, 2009, 03:57 PM)
--- End quote ---

nope, I don't have the "word", "word1", "word2" etc stored in an excel file, but I can do this if it is needed
also, please note that the "word", "word1", "word2" etc are specific data, not variables

what you want to do is to have the related items filled in whenever you choose a particular instance of "word"
-David1904 (April 30, 2009, 03:57 PM)
--- End quote ---

what I want is to have the related data automatically filled ("word1" in "column1", "word2" in "column2", etc, in the line I typed the "trigger" "word")
the trigger event that will trigger the autofill of data would be to write "word" in a specific column named "column" (but if that's too hard, let's just say to only write the "word" in any column)

If this is the case, then using VLOOKUP or HLOOKUP would probably be you answer.
-David1904 (April 30, 2009, 03:57 PM)
--- End quote ---
not sure about those functions, by I would suppose that a macro could do what I need? just by resembling what I want to do with some macros in office that autowrite "by the way" after you type btw or something...

tranglos:
hello

I would like to do this in MS EXCEL:

when I type a specific "word" in a column named "column" to automatically write in the same line: "word1" in "column1", "word2" in "column2" etc (in other words to autofill the other cells of the line with specific data for each collumn)
-kalos (April 30, 2009, 03:17 PM)
--- End quote ---

I'm not sure this will help you do what you want, but try this: type "word1" in a cell. Click this cell. There will be a tiny black square in the bottom right corner. Click this square (this is a little fiddly - the mouse cursor should change to a small black plus sign), then drag down, as far as you wish. Excel will fill the column cells with "word2", "word3", etc.  If you drag to the right, Excel will likewise fill the row.

This works not only for numbers, but also for days of the week, months, and any lists you define manually.

Is this anywhere near what you need? It does need manual dragging; it won't happen automatically as-you-type, though. For automatic behavior, you would need a formula, but I cannot find anything that looks like the "autoincrement" described above in the list of formulas in Excel 2003.

Target:
do you want the same entry across the row, like this?

Row1 col1 = word1, col2 = word1, col3 = word1
Row2 col1 = word2, col2 = word2, col3 = word2

if so, simply put the formula =$a1 in each of the columns, then fill down the requisite number of rows

Navigation

[0] Message Index

[#] Next page