Solved

Auto fill Word chart with Boiler plate text

Posted on 2014-01-17
2
680 Views
Last Modified: 2014-01-22
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?
0
Comment
Question by:lcor
2 Comments
 
LVL 39

Assisted Solution

by:als315
als315 earned 250 total points
ID: 39789201
I think it is impossible in Word, but it is very easy in Excel. Look at sample
Keywords.xlsx
0
 
LVL 14

Accepted Solution

by:
DrTribos earned 250 total points
ID: 39789834
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.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now