Automatically extract data from a table into another word document

OfficeAssociate99 · #1 05-26-2017, 10:57 AM

Hi,

I need to do a few things. First, I need extract data from around 6-7 other word documents and automatically have the data entered in specific areas of a table in a single "master document". The second thing is that this is updated on a weekly basis, and records are kept in another table in the master document of all the previous information. Therefore, it would be great if I could automate the process so that all the old data is automatically shifted from the "current" table to the "previous" table.
Any help would be greatly appreciated.

macropod · #2 05-28-2017, 11:19 PM

If you bookmark the tables in each of the source documents, you could use INCLUDETEXT fields in the destination document referencing the bookmarks in the source documents. That way, the destination document can auto-update to reflect the changes in the source document without the need for any code. See:
https://support.office.com/en-us/art...a-2ff950fb629e

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatically extract cells to summary table	taryn	Excel	2	05-04-2016 04:50 AM
extract specific pivot table data to a new sheet	theexpat	Excel Programming	0	02-18-2016 10:08 AM
How to Extract Data from table based on pattern.	PRA007	Word Tables	4	03-17-2015 11:05 PM
Automatically annotate image with Word table data from Word 2003	donaldadams1951	Word	3	02-09-2015 05:46 PM
VBA Code to take data from a table in word document and place it in a summary table	VBLearner	Word VBA	1	03-09-2014 08:42 PM