Macro to transfer tabulated data from Excel to Word

[excelaverage]

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.

I have some data in excel as in the attached. It's all data about items.

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.

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.

[TiggsTravis]

Not sure from your post if you want to take the data from Excl and put it into the Word document. You could do a copy and paste, however, the column widths in Word may not match.

Another alternative is to perform a mail merge. This will keep the table setup in MSWord the same. The one caviot is that your data in Excel will need only one row for the heading and contain no blank rows within the worksheet.