Reply
 
Thread Tools Display Modes
  #1   Report Post  
jada
 
Posts: n/a
Default Linking Excel cells to a Word document

I would like to create a word document which I can link to certain cells in
an excel document. For example imagine I created an empty table in word. I
would like to link some of the cells of this table to certain cells in an
excel spreadsheet.
and once I link them I would like to assign a key to the function like an F
key maybe and perform the transfer of the cells at once.
The main purpose is to create a visual document in Word and keep the data in
excel and mapping certain cells to eachother and finally hitting one key to
make the transfer. As the excel table is updated with live data I should be
able to update the word documewnt as well by hitting one key. I am not sure
if I should do this by mail merge or by assigning macros. If I need to assign
macros (which I tried but was unsuccessfull in mapping) could you tell me
how, for example walk me through the mapping of one cell and I can do the
rest....Many Thanks....

  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default Linking Excel cells to a Word document

You can certainly link Excel cells into a Word document - paste special/as
link and while both the document and the spreadsheet are open any changes to
Excel are immediately reflected in Word. I would, however, recommend that
you perform all the calculations in Excel and insert the complete table
rather than insert individual cells into a Word table, or you may have
problems with the formatting.


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



jada wrote:
I would like to create a word document which I can link to certain
cells in an excel document. For example imagine I created an empty
table in word. I would like to link some of the cells of this table
to certain cells in an excel spreadsheet.
and once I link them I would like to assign a key to the function
like an F key maybe and perform the transfer of the cells at once.
The main purpose is to create a visual document in Word and keep the
data in excel and mapping certain cells to eachother and finally
hitting one key to make the transfer. As the excel table is updated
with live data I should be able to update the word documewnt as well
by hitting one key. I am not sure if I should do this by mail merge
or by assigning macros. If I need to assign macros (which I tried but
was unsuccessfull in mapping) could you tell me how, for example walk
me through the mapping of one cell and I can do the rest....Many
Thanks....



  #3   Report Post  
jada
 
Posts: n/a
Default Linking Excel cells to a Word document

First of all thanks for your reply but when I do copy paste instead of
pasting a limk or function it pastes the information directly from my excel
spreadsheet. I belıeve I need to use a macro which can copy data from
dirrerent tabs in excel into different cells in word and do it at once by
hitting one key. The problem is I cannot remember exactly how it is done. I
start recording a macro but as I do the copy pasting it seems to not
function...İf you could help me with this I would highlt appreciate it.

Jada


"Graham Mayor":

You can certainly link Excel cells into a Word document - paste special/as
link and while both the document and the spreadsheet are open any changes to
Excel are immediately reflected in Word. I would, however, recommend that
you perform all the calculations in Excel and insert the complete table
rather than insert individual cells into a Word table, or you may have
problems with the formatting.


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



jada wrote:
I would like to create a word document which I can link to certain
cells in an excel document. For example imagine I created an empty
table in word. I would like to link some of the cells of this table
to certain cells in an excel spreadsheet.
and once I link them I would like to assign a key to the function
like an F key maybe and perform the transfer of the cells at once.
The main purpose is to create a visual document in Word and keep the
data in excel and mapping certain cells to eachother and finally
hitting one key to make the transfer. As the excel table is updated
with live data I should be able to update the word documewnt as well
by hitting one key. I am not sure if I should do this by mail merge
or by assigning macros. If I need to assign macros (which I tried but
was unsuccessfull in mapping) could you tell me how, for example walk
me through the mapping of one cell and I can do the rest....Many
Thanks....




  #4   Report Post  
Doug Robbins - Word MVP
 
Posts: n/a
Default Linking Excel cells to a Word document

See the article "Control Excel from Word" at:

http://www.word.mvps.org/FAQs/InterD...XLFromWord.htm

and "Control Word from Excel" at:

http://www.word.mvps.org/FAQs/InterD...WordFromXL.htm


--
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

"jada" wrote in message
...
First of all thanks for your reply but when I do copy paste instead of
pasting a limk or function it pastes the information directly from my
excel
spreadsheet. I believe I need to use a macro which can copy data from
dirrerent tabs in excel into different cells in word and do it at once by
hitting one key. The problem is I cannot remember exactly how it is done.
I
start recording a macro but as I do the copy pasting it seems to not
function...If you could help me with this I would highlt appreciate it.

Jada


"Graham Mayor":

You can certainly link Excel cells into a Word document - paste
special/as
link and while both the document and the spreadsheet are open any changes
to
Excel are immediately reflected in Word. I would, however, recommend that
you perform all the calculations in Excel and insert the complete table
rather than insert individual cells into a Word table, or you may have
problems with the formatting.


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



jada wrote:
I would like to create a word document which I can link to certain
cells in an excel document. For example imagine I created an empty
table in word. I would like to link some of the cells of this table
to certain cells in an excel spreadsheet.
and once I link them I would like to assign a key to the function
like an F key maybe and perform the transfer of the cells at once.
The main purpose is to create a visual document in Word and keep the
data in excel and mapping certain cells to eachother and finally
hitting one key to make the transfer. As the excel table is updated
with live data I should be able to update the word documewnt as well
by hitting one key. I am not sure if I should do this by mail merge
or by assigning macros. If I need to assign macros (which I tried but
was unsuccessfull in mapping) could you tell me how, for example walk
me through the mapping of one cell and I can do the rest....Many
Thanks....






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
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
How do I create a Word form like corel WP merge documents? dlee_at_mmsgov Microsoft Word Help 2 October 8th 05 06:29 AM
Macros - Keyboard Commands Janet Microsoft Word Help 6 April 11th 05 05:28 AM
In Word, how can I see all files (*.*) in "save as"? citizen53 New Users 8 April 4th 05 04:56 PM
WordPerfect keyboard macro>Word equivalent? Anty New Users 2 March 13th 05 07:23 PM


All times are GMT +1. The time now is 04:53 AM.

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

About Us

"It's about Microsoft Word"