W
Wuddus
I have a Word document embedded within an Excel workbook. (The document is
set to appear as a clickable icon in Excel; clicking it opens the Word doc.)
The document is essentially a big table that, for various reasons, is not
practical to place directly into the Excel spreadsheet.
The header of the Word table has fields for basic info: You know, "Submitted
By," "Department," stuff like that. All of this info appears in the Excel
spreadsheet itself, too. Instead of asking users to duplicate their efforts
and enter this stuff in both places, can I set the Word fields to pick up the
text from the equivalent cells in Excel? For example, the top left cell in
the Word table is for the user's name. The user has already entered this cell
on the Excel sheet in cell C2. Can I tell the Word cell to just pick up the
text from Excel cell C2?
Help! If I can get this to work, it'll help users a lot and cut down on the
chance that the Word doc won't be filled out completely or correctly.
Thanks in advance for any help you can offer!
set to appear as a clickable icon in Excel; clicking it opens the Word doc.)
The document is essentially a big table that, for various reasons, is not
practical to place directly into the Excel spreadsheet.
The header of the Word table has fields for basic info: You know, "Submitted
By," "Department," stuff like that. All of this info appears in the Excel
spreadsheet itself, too. Instead of asking users to duplicate their efforts
and enter this stuff in both places, can I set the Word fields to pick up the
text from the equivalent cells in Excel? For example, the top left cell in
the Word table is for the user's name. The user has already entered this cell
on the Excel sheet in cell C2. Can I tell the Word cell to just pick up the
text from Excel cell C2?
Help! If I can get this to work, it'll help users a lot and cut down on the
chance that the Word doc won't be filled out completely or correctly.
Thanks in advance for any help you can offer!