PDA

View Full Version : Excel 2007 - export data from Excel to Word 2007



chamdan
03-31-2012, 11:32 AM
I have a spreadsheet that contains extracted data from a ms project schedule part of the data available in this worksheet is as follow:


Task ID WBS Unique ID Task Name
21 1.2 209 Test Book 3 is Produced
Col M Col L Col AI Col B:K
Column AZ Contains a Cell that is made of the concatenation of cells AD to AH

Feb. 14, 2012
the purpose of Test Book 3 is to the following 3 main activities.
1. To confirm the durability, Adversarial, Interoperability, the Chip and the Quality of the book.
2. Is to be used in i2012-Mar-19
Dependencies required...

I would like to copy this data from the Excel spreadsheet and save them into a word document in the format you see above.

I know it can be done but do not know how to.

I have been able to paste this information to word but could not format it the way you see above.
Each of the data listed above correspond to one row in the worksheet. There are around 2000 rows.

I wish to separate each of the Task ID I mean each row and content pasted into the word must be separated by at least one line or two.


Look forward to hearing from you.


Regards,


Chuck:help