Excel data to Word table template

B

Barrie

I have a Word 2007 template for a monthly report that includes a formatted
table. When I delete the data and try to copy and paste the updated rows and
columns from Excel 2007, it all wants to go into the top left cell. Of
course, I can copy over the data as a table but then I lose my formatting.
How should I be going about this?
 
D

Doug Robbins - Word MVP

If this is something that you do each month, it would be worthwhile linking
the content of each cell in the Word table to the corresponding cell in
Excel.

Then all you will need to do is select the table and press F9 to update the
fields.

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

Doug Robbins - Word MVP

You only have to do it once.

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

Graham Mayor

The alternative is to format the Excel table as you have it in Word and link
the table.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
B

Barrie

Now you tell me! :)

Graham Mayor said:
The alternative is to format the Excel table as you have it in Word and link
the table.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Click to expand...
 
Top