View Single Post
 
Old 06-10-2014, 11:19 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

Unless there is always a fixed relationship between the tables in the two documents, this would be a difficult task.

Although you say "Cells in the two documents are similar but formatted exactly the same", that's not really the case. For example, whereas your B document has a separate cell for headings such as 'LEARNING ACTIVITIES', your A document has those headings in the same cells as the content to which they relate. Consequently, even if there is a fixed relationship between the documents, one can't simply transfer entire cell contents - some editing would also be required.

If there isn't a fixed relationship, the difficulties associated with automatically transferring the data increase substantially.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote