Copy a tabulated data From Excel to Word

ExcelAverage

New Member
Joined
Dec 10, 2012
Messages
32
Hi everyone,

I am very new in using excel. Suddenly I had to do something to make this one newly transitioned ask easier. I just know that it's shouldn't be this hard to do but I just don't that skills to code or program something.

Item Name, Description, Price
It's written somewhere in my spreadsheet with these headings. Sometimes they're an item of one or two. So regardless of the count, the whole bunch should be transferred to Word. my word file has some headings then in the middle should be where the data be placed then the bottom part is additional comments again.

EXCEL FILE
partNumber
Description
Unit Cost
Qty
Std cost
JGC123XLT

<colgroup><col width="210"></colgroup><tbody>
</tbody>
Paper Towel Holder for use in the factory. This item is sometimes used also at home. We always give customer total satisfaction with this item. Please contact our sales rep for inquiries
$ 12.00
1
$ 12.00

<tbody>
</tbody>



















WORD FILE

Headings
headings
partNumber
Description
Unit Cost
Qty
Std cost
JGC123XLT

<colgroup><col width="210"></colgroup><tbody>
</tbody>
Paper Towel Holder for use in the factory. This item is sometimes used also at home. We always give customer total satisfaction with this item. Please contact our sales rep for inquiries
$ 12.00
1
$ 12.00

<tbody>
</tbody>

<tbody>
</tbody>




notes notes












additional comments
additional comments
additional comments
additional comments


by the way my word doc still has headings and some notes and comments at the last part. I need to put the table in the middle after the opening information.
is this something we can do in excel?

Or maybe, is it possible that the table is already fix in the Word doc and the data will just be dumped in. So the table formatting can be retained. Thanks and sorry for the many questions.

Please help. If you have any queries. please ask me.

Many Thanks in advance

Ju M.
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Sorry the part number should have the box like that in my tabulation. just normal txt like the description. thanks
 
Upvote 0

Forum statistics

Threads
1,214,639
Messages
6,120,679
Members
448,977
Latest member
dbonilla0331

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top