Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I link info in MS Word into Excel and will it update?
I want to keep a status of updates in an Excel file of all accounting work
instructions that are written in MS Word. I want to show in Excel who reviewed the MS word files and the date. As these work instructions are updated, I'm having the person place their name and the date of the update into a specific area of the MS word file. I would like the Excel file to be updated with the reviewer's name and date of update simultanuously as it is changed in MS word. Appreciate any help/suggestions you may have... Best Regards, R Ritenour |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I link info in MS Word into Excel and will it update?
Hi RRitenour,
If the update info in Word is in a table, you can copy the table & use Edit|Paste Special, choosing the 'Paste Link' option in Excel to establish a link between the two documents. From then on, any changes to the Word table will be reflected in the corresponding object embedded in Excel. -- Cheers macropod [MVP - Microsoft Word] "RRitenour" wrote in message ... I want to keep a status of updates in an Excel file of all accounting work instructions that are written in MS Word. I want to show in Excel who reviewed the MS word files and the date. As these work instructions are updated, I'm having the person place their name and the date of the update into a specific area of the MS word file. I would like the Excel file to be updated with the reviewer's name and date of update simultanuously as it is changed in MS word. Appreciate any help/suggestions you may have... Best Regards, R Ritenour |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Word copying info from Excel to Word without gridlines / bor | Excel Discussion (Misc queries) | |||
How do I update link from excel to word? | Excel Worksheet Functions | |||
Link table from excel to word using word VBA | Excel Discussion (Misc queries) | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Am I able to link excel info with word and have it change when i c | New Users to Excel |