add additional data to word document's bookmark in excel

**RonNCmale** · 11-02-2011, 09:33 PM

I have an excel workbook that has seven worksheets tabs and on the last tab it has a a merge data button that enters the total for all the worksheet onto a word template. I works just fine. I need to add the report number to the word template that corresponds to the appropriate incident that is checked. I've attached the workbook and a word document of what the template should look like when merged.

any help would be greatly appreciated.

also posted here:http://www.vbaexpress.com/forum/showthread.php?t=39548

**Leith Ross** · 11-03-2011, 02:06 AM

Since you have chosen to accept the solutions at the site you provided a link to, this post will be closed.

EDIT: Contacted by Ken Hobson at VBAX who said he does not have time to help further on the project. This post still requires a solution.

**RonNCmale** · 11-03-2011, 03:58 PM

This is the code K. Hobson so graciously provided that I could not figure out. Any help would be appreciated. Thanks

Please Login or Register  to view this content.

**snb** · 11-03-2011, 05:20 PM

1. Bookmarks have been designed for Word's Userinterface
2. when using VBA you'd better apply documentvariables.
3. the amount of coding is dependet of the amount of structuring the data in the workbook.
4. Put the formulae, which results have to be put into the documentvariables of the Word document, into column K of a sheet (e.g. the sheet Disciplinary Report).
5. the 'transfercode' can be:

Please Login or Register  to view this content.

Cfr. the attachments

**RonNCmale** · 11-04-2011, 04:23 PM

I still don't understand! I downloaded the attachments and when I click the merge records nothing happens, Am I missing something here?

Mr. Hobson came up with this code that does what I want, but it only works for the worksheet that the merge data button is on and all other data is lost. I have six worksheets that data has to be pulled from. I need this code modified to loop through all worksheets and enter all data to the word template and also the merge data button to be on the last sheet. I've attached the files also.

Please Login or Register  to view this content.

**RonNCmale** · 11-05-2011, 10:36 PM

Anyone have any other ideas as in a formula that could for each x return a report number(s) to a cell. I could then add to template as a bookmark.

**RonNCmale** · 11-06-2011, 04:14 PM

From the following thread:
http://www.excelforum.com/excel-prog...ave-blank.html
Is there a way to modify this formula:
=IF(ISERROR(MATCH($A7,J$2:J$4,0)),"","X")
to place results into the same cell. example:
FordWords ChevyWords DodgeWords
Item,Betty,Bobby Manly,From,Home Ram,Hard,Tree