View Single Post
 
Old 03-25-2012, 07:17 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
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

Hi Kannon,

It's quite easy to do this, using INCLUDETEXT fields. See attached.

With the approach taken in the attached files, each department inputs its data into bookmarked one-cell tables - one per topic. Each cell can contain multiple pages of content, including graphics, etc, if need be. When completed, they send their reports to you and you put them into the same folder as your consolidated report. The consolidated report uses the INCLUDETEXT fields to import the bookmarked tables from each department's reports. When you want to generate a consolidated report, simply open it, press Ctrl-A, then F9 to update it before printing. If you set Word's 'update fields before printing', 'update linked data before printing' and 'update automatic links at open' options, you probably won't even need to do that.

If you want to save a permananet copy of the consolidated report, open it, press Ctrl-A, F11 to lock the fields (or Ctrl-Shift-F9 to unlink all the content and turn the fields into just their displayed content), then save with a new name.
Attached Files
File Type: zip Reports.zip (74.3 KB, 35 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote