Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 20
Default Word & Excel

Hi,

I would like to link Excel cells to fields in Word. I have Word documents
that use fields and I would like to have an excel file automatically grab the
value of those fields.

Thanks for your help

  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 91
Default Word & Excel

I believe the way to do this is by copying the range in Excel and then
go to your Word Document, at the top menu select Edit=Paste Special
In the Paste Special window, select Paste Link, then select Microsoft
Office Excel Worksheet Object. Changes in the excel range should
change in the Word Document
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 20
Default Word & Excel

Thanks for the response, but I want to go the other way. First, write up the
Word document and then have Excel automaticlly fill in information based on
the Word document.

"damorrison" wrote:

I believe the way to do this is by copying the range in Excel and then
go to your Word Document, at the top menu select Edit=Paste Special
In the Paste Special window, select Paste Link, then select Microsoft
Office Excel Worksheet Object. Changes in the excel range should
change in the Word Document

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 7, paste linked to word becomes black when word pdf'd Surffreak Excel Discussion (Misc queries) 0 June 1st 08 12:17 AM
Excel Word copying info from Excel to Word without gridlines / bor Renee Thomas Excel Discussion (Misc queries) 2 September 13th 07 09:24 AM
Copy from Word to Excel, and retain indent, plus word wrap Eric Excel Discussion (Misc queries) 1 March 9th 07 03:15 AM
Link table from excel to word using word VBA [email protected] Excel Discussion (Misc queries) 7 January 9th 07 05:57 PM
Print labels by using Excel data in a Word mail into word Zoey Excel Discussion (Misc queries) 1 November 1st 05 09:08 PM


All times are GMT +1. The time now is 12:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"