#1
|
|||
|
|||
How to copy automatically data from Excel file to Word file?
Hi, is there any chance to move (copy) automatically data from excel (as a number from box) onto word file without opening this file? I have to copy a lot of data every single day from one word file onto excel file via copy-paste and it makes me crazy is there any option to make it automatically?
Many thanks in advance for help. |
#2
|
|||
|
|||
Which way?
you do not make it clear whether you are copying from Word to Excel or vice versa; you say both. In either case, without further information about the document into which you are copying, it's had to advise. Are you aware that you can embed an Excel file into Word? you might wish to look this up.
Cordially, Ulodesk |
#3
|
|||
|
|||
Hi
thank you. I am thinking about some kind of automatically coping form one file (excel) to another (word). Mayby is there any chance to import data with automatically update ? |
#4
|
||||
|
||||
Hi fuchsd,
You can create a link between Excel and Word by selecting a range in Excel, copying it, then activating the Word document, selecting the destination and choosing Edit|Paste Special, checking the 'paste link' option and choosing the paste format you desire. From then on, any change to the Excel data should be reflected in Word (you may need to go to Tools|Options|General and make sure the 'Update automatic links at open' option is checked).
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
:)
that's the one!
thank you so much for your help. Is there any chance to update automatically link during file editing ? (without another re-open the file and not F9 key?) |
#6
|
||||
|
||||
Hi fuchsd,
The only way that can be done is to have both files open whilst editing in Excel (works for me).
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
:)
That's great! Thank you so much for your help
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to restore original data format - from a .pdf file to Excel columns | KIM SOLIS | Excel | 1 | 09-18-2011 10:49 PM |
Can Word automatically do "Finish and Merge" after opening file? | DaveBF | Mail Merge | 1 | 09-14-2011 07:56 AM |
Help! Find text in doc file & copy to another file | northstarman | Word | 1 | 11-05-2010 08:15 AM |
Excel file lost data how to recover it | zillah | Excel | 1 | 02-10-2010 08:36 PM |
copy a file which does not have copy option | jkind | Word | 0 | 01-17-2010 09:25 AM |