Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
enter info to msword-it automatically enters in an excel cell
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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
enter info to msword-it automatically enters in an excel cell
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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get Excel information inserted into Word Table cell? | Microsoft Word Help | |||
Any way to copy two paragraphs from one cell to multiple cells? | Tables | |||
I can enter all custom info for a label except the page size. | Microsoft Word Help | |||
how do I set up a field, so when the user enters in info the fiel. | Microsoft Word Help | |||
how do I enter info on templates without shifting whole document.. | Microsoft Word Help |