?
Solved

Auto fill Word chart with Boiler plate text

Posted on 2014-01-17
2
Medium Priority
?
756 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Assisted Solution

by:als315
als315 earned 1000 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 15

Accepted Solution

by:
DrTribos earned 1000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

771 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