I need to create a Word document from an Excel document and format.?

Question

I collect data in an excel document. I then need to take some of the data from the Excel document and create a professional looking Word document. I want this to happen as automatically as possible and dynamic. One excel document will correspond to one Word document. Copy and paste don't work because it is not automatic enough and is not dynamic. Copy and paste special does not work because even though it is now dynamic, I cannot format. Data is held in excel file in one column.

Answer 1

Copy and paste is a static copy and does not dynamically update.



I think you are talking about embedding data from excel into a word document so that any change to the data in excel is automatically updated in the word document. This article may help. It talks about powerpoint as well but the process is the same in Word.



http://kan.org/tips/powerpoint_charting.php

Answer 2

There should not be a problem coping and pasting from Excel to Word. Make sure you select the proper fields and columns before copying and paste into the area you want the data in the Word file. Is your Office programs using the latest service pack and updates?

Answer 3

id say the best way to do that. is to create a PDF from an excel sheet, File->save as->Pdf. Then from there you can create a word document.



Another way is to create a table in word and transfer the data, but wouldnt be useful if there is a lot of data