Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 09-29-2017, 08:34 AM
Charles Kenyon Charles Kenyon is offline Consolidating data from Word into one Excel Windows 10 Consolidating data from Word into one Excel Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,530
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Word needs a way to know what it is you want consolidated. Bookmarks are one way. A special style is another. Some of your data has bookmarks, but not all. Some has labels, but not all.

Off hand, for me, it would probably be simplest to copy and paste from the Word documents one at a time.

If each of your documents has identical layout, with your data in exactly the same place, it should be possible to automate, but, for me, it would be a challenge.

Once I was done with the manual conversion, I would probably design a data entry form of some sort in Word (or Access) and use that in the future.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data? Hoser Word 1 03-17-2017 03:47 PM
Consolidating data from Word into one Excel Consolidating various word docs in one Max Downham Word 6 11-23-2015 05:07 PM
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data Faldinio Word VBA 7 10-19-2014 06:03 AM
Consolidating data from Word into one Excel Need help consolidating data from separate sheets tiwas Excel 1 10-07-2014 04:57 AM
Consolidating data from Word into one Excel Consolidating data using Macro mrjamez Excel Programming 2 05-22-2012 06:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:48 AM.


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