link word data and excel

[Guest]

how do I get info I enter in a cell in a table in word to appear in a
specific cell in excel?
-when I enter a person's name I want it to automatically show up in an excel
cell then have the cursor move to the next cell down

 

[Cindy M.]

Hi =?Utf-8?B?Q2hlcmkgRw==?=,

how do I get info I enter in a cell in a table in word to appear in a
specific cell in excel?

Select the cell. Insert bookmark and enter a name for the bookmark. Make sure
the cell is selected. Copy. Switch to Excel and use Edit/Paste special.
Activate the "Link" option. Choose to paste as text.

-When I enter a person's name I want it to automatically show up in an excel
cell then have the cursor move to the next cell down

There's no way you can get the cursor to move down automatically. How should
Word know you've finished? Just press the Down arrow on the keyboard.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail