Reply
 
Thread Tools Display Modes
  #1   Report Post  
Dr. Darrell
 
Posts: n/a
Default ... 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   Report Post  
Doug Robbins
 
Posts: n/a
Default

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   Report Post  
Dr. Darrell
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying Excel data into Word: setting the Tabs Sam Page Layout 4 July 17th 05 05:01 AM
Difficulty pasting Excel data into Word table only in XP versions Digitonomy Tables 0 February 28th 05 12:33 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM
Word Field Codes in Excel data file mranz Mailmerge 7 December 11th 04 09:02 AM


All times are GMT +1. The time now is 08:50 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"