Home |
Search |
Today's Posts |
#1
|
|||
|
|||
... interaction with Excel ...
I would like to link some lines in my word document to Some cells of an
existing Excel Spreadsheet. In otherwords: Excel File: Scrap Tracking.xls Worksheet: Apr-05 Cell-1: E2 (Text = April-05) Cell-2: C100 (Text = Monthly Total) Cell-3: D100 (Text = $3,879.09) I would like a Sentence in my Word Document to read: .... During "April-05" the "Monthly Total" Scrap Value was "$3,879.09" ... Is there a way to do that? Thanks, Darrell |
#2
|
|||
|
|||
EditPaste SpecialPaste as Link, most probably selecting the unformatted
text option. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Dr. Darrell" wrote in message ... I would like to link some lines in my word document to Some cells of an existing Excel Spreadsheet. In otherwords: Excel File: Scrap Tracking.xls Worksheet: Apr-05 Cell-1: E2 (Text = April-05) Cell-2: C100 (Text = Monthly Total) Cell-3: D100 (Text = $3,879.09) I would like a Sentence in my Word Document to read: ... During "April-05" the "Monthly Total" Scrap Value was "$3,879.09" ... Is there a way to do that? Thanks, Darrell |
#3
|
|||
|
|||
Doug:
I was looking for a paste Special Command, I don't know how I overlooked it. TY Darrell PS I went to school with a Doug Robbins, we Graduated in 1974. Is that your vintage? "Dr. Darrell" wrote: I would like to link some lines in my word document to Some cells of an existing Excel Spreadsheet. In otherwords: Excel File: Scrap Tracking.xls Worksheet: Apr-05 Cell-1: E2 (Text = April-05) Cell-2: C100 (Text = Monthly Total) Cell-3: D100 (Text = $3,879.09) I would like a Sentence in my Word Document to read: ... During "April-05" the "Monthly Total" Scrap Value was "$3,879.09" ... Is there a way to do that? Thanks, Darrell |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Excel data into Word: setting the Tabs | Page Layout | |||
Difficulty pasting Excel data into Word table only in XP versions | Tables | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
Word Field Codes in Excel data file | Mailmerge |