Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-26-2017, 10:57 AM
OfficeAssociate99 OfficeAssociate99 is offline Automatically extract data from a table into another word document Windows 7 64bit Automatically extract data from a table into another word document Office 2010 64bit
Novice
Automatically extract data from a table into another word document
 
Join Date: May 2017
Posts: 19
OfficeAssociate99 is on a distinguished road
Default Automatically extract data from a table into another word document

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.
Reply With Quote
  #2  
Old 05-28-2017, 11:19 PM
macropod's Avatar
macropod macropod is offline Automatically extract data from a table into another word document Windows 7 64bit Automatically extract data from a table into another word document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically extract data from a table into another word document 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
Automatically extract data from a table into another word document How to Extract Data from table based on pattern. PRA007 Word Tables 4 03-17-2015 11:05 PM
Automatically extract data from a table into another word document Automatically annotate image with Word table data from Word 2003 donaldadams1951 Word 3 02-09-2015 05:46 PM
Automatically extract data from a table into another word document 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft