Auto fill Word chart with Boiler plate text

I have a Word 2010 document with a chart with two columns and many rows.

I would like to fill in the second column automatically with boilerplate text based on a keyword in the first column.

If this can't be done in Word, can it be done in Excel?

Anyone know how to do this?
Who is Participating?
DrTribosConnect With a Mentor Commented:
Yes it can be done in Word using a macro - the macro would look in the table and process each cell.  What exactly would you like to achive?

Example of macro structure might be something like this:
Sub ProcessTable()
dim oCell as Cell

For each oCell in ActiveDocument.Tables(1).Columns(1)
'Read cell 1
'Write to cell next to cell 1
Next oCell

End Sub

Open in new window

Pls upload a sample document.
als315Connect With a Mentor Commented:
I think it is impossible in Word, but it is very easy in Excel. Look at sample
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.