Forward and Reverse Merge

Originally Posted by Joe_

This is both an Excel and Word question.

I'm currently writing a book that, because it involves different but repeating segments that can be written out of order, works perfectly in tandem with setting up an Excel Word merge.

In other words, I work on relevant cells in Excel and they're merged into the Word document. (Added to the Word document are introductions, sidebars, etc.)

Now that I'm largely (not completely) finished with my Excel work I'm looking at the Word document. As expected, for reasons of unity and continuity I'm going to have to significantly edit the Word document.

I want my word edits to be reflected in the Excel file.

It's easy to set up a merge from Excel -> Word.
1) Can one set up a merge in the opposite direction, from Word -> Excel and
2) Can one use the existing merge document as the basis for the reverse merge?

Thanks

Hi,

The suggestion is that you read the Word edition and edit the Excel to suit.

You could write some VB code to 'read' the Word document and replace each desired section in Excel, but truly I do not envy you such a task, it would be far easier and cheaper to hire a copy-typist to do the fix from Word to Excel.

Depending how your document is setup you could try,
In the Word document, Ctrl/A (select all) and in Excel Paste Special = Values to a new sheet to see how closely this can equate to your original Excel version. Anything derived from an Excel formula will, of course, need the original Excel portion.

hth
---