Hi,

I would greatly appreciate your help with eliminating, using macros, an unproductive word process I currently use.

My company uses a word template to prepare our client reports. We gather data in the form of typed text (about 20 pages long in each report). This data leads to two types of insights - strengths and risks. In each report we usually come up with ~10 strengths and ~6 risks. We create a headline (a one sentence description of the strength/risk) for each strength and risk, and under each such headline, we paste selected paragraphs from the 20-pages of raw data as evidence for that particular strength or risk.



Given this context, I would love to understands how I can do the following 2 things:

1. Create a macro to automatically tag a certain text string/paragraph as a strength or a risk (e.g., I will have around 4-5 paragraphs of evidence for strength 1, 4-5 for strength 2 etc.)
2. Automatically paste all text strings tagged as strength 1 under the headline for strength 1 in the synthesis section etc. (each separate instance of tagged data needs to be pasted as a separate bullet point)

It would be great if I can keep a dynamic link between the text in both places so I don't have to edit twice. With my limited VBA knowledge, I imagine the solution could look like 10 "strength" buttons and 6 "risk" buttons in the QAT so I can select some text and click on one of these buttons to tag it.

'Automatically' may be a bit of a stretch. You are going to have to select the text you 'tag' before you can tag it (or the paragraph containing it), and then you are going to have to run the macro to process the information. However, how do you plan to tag the text. What do you mean by 'tag' in this context.

You could perhaps bookmark the text then insert a cross reference to the bookmark. http://www.gmayor.com/BookmarkandVariableEditor.htm will display all the bookmarks in the document, with their values, and will create cross references. That may help, but until you define what you mean by 'tag' in this context, that's as good as it gets.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com