![]() |
#1
|
|||
|
|||
![]() Hi I have 8-9 Documents that I have to create for different cases. Each document remains largely the same with a few details changed each time. Is there a way of having an excel sheet with the changed data on and using it to populate a group of templates all at once. i.e. I create an excel sheet with the unique data apply it to group of templates and word creates 9 unique documents. Thanks, Jonathan |
#2
|
||||
|
||||
![]()
If you configure the Excel workbook so that the data the Word document are to reference are always in the same location (eg by having a separate worksheet where the reference data appear), you can create links by copying the Excel cells, then pasting the content into Word using Paste Special with the 'paste link' option. Note that several paste formats are supported. Experiment to see which format(s) best suit your needs.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
Tags |
merge, template |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to create charts and graphs as in templates. | rohit007 | PowerPoint | 0 | 08-16-2012 12:18 AM |
Managing multiple templates | dtenter | PowerPoint | 0 | 05-22-2012 09:20 AM |
![]() |
kckay | Word VBA | 1 | 05-17-2012 08:51 PM |
Share VBA variable in multiple templates | shameerau | Word VBA | 0 | 07-05-2010 08:37 PM |
Create Multiple Tabs from Template | TeePee | Excel | 0 | 04-30-2009 11:54 AM |