#1
|
|||
|
|||
Inputing Text from Excel sheet to multiple Word documents and Visio File
I have to fill out some paperwork which involves inputting the same information (name, address, phone, etc) into multiple word documents and a visio sheet.
I was hoping I could create one excel or word document to input the information into. Then this document would automatically input the information into all the other documents. I know there is a way to link text boxes, but I just dont know of a way to do that with multiple different files. Any help would be greatly appreciated! Thanks Edit - I should probably mention that I am currently using office 2010 with visio 2003. On my home computer I have Office 2013 installed, so if its much easier to use I can upgrade to 2013 once I figure out how to do it. |
#2
|
||||
|
||||
Hi Jazz,
If the workbook is always the same and the Word documents are always the same, you can copy/paste the Excel cells to the Word documents, using the 'Paste Special' method with the 'paste link' option, with whatever paste format best suits your needs. From then on, any changes to the Excel data will be reflected in the documents. I don't use Visio, but I imagine it has something similar.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to import multiple text file data into word | mizankabir | Word VBA | 7 | 09-15-2023 10:27 PM |
Replace text in multiple documents? | Roscoe | Word VBA | 7 | 07-31-2017 04:02 PM |
search on multiple word documents | Guy Roth | Word | 7 | 03-06-2017 01:31 PM |
Combining Multiple Word Documents Heading/Figure Issues Word 2007 | grantgibson45 | Word | 1 | 09-10-2012 11:00 PM |
Word count in multiple documents | cyberpaper | Word | 5 | 07-27-2012 07:31 PM |