[Cheri G]

I want to enter a phone # in a table cell in ms word and have it
automatically show up in a list of #'s in excel
this is so I don't have to cut and paste and toggle between pages

[Cindy M.]

Hi ?B?Q2hlcmkgRw==?=,

I want to enter a phone # in a table cell in ms word and have it
automatically show up in a list of #'s in excel
this is so I don't have to cut and paste and toggle between pages

This would require some pretty fancy macro programming, I'm afraid.

Simplest for you would be to write the phone numbers in Excel.
Select the entire table and turn it into a List (Data/List/Create
list).
Make sure the entire List is selected and assign it a Name (click
in the box at the left of the formula bar and type a name, such as
PhoneList)
With the list still selected, COPY.
Switch to the Word document where you want to see the phone list.
Edit/Paste Special and activate LINK. OK.
Press Alt+F9 to see the field codes. You should see something like
{ LINK Excel.Sheet.8 Book3 "Sheet1!R1C3" \a \f 4 \h \* MERGEFORMAT
}

Delete the R#C# and type in the range name. The result should look
something like
{ LINK Excel.Sheet.8 Book3 Sheet1!PhoneList \a \f 4 \h \*
MERGEFORMAT }

Now the list in the Word document should update to reflect what's
typed into the Excel list.

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