Automatically Transfer Data from Excel to Word

[ExcelPadawan]

I am still learning Excel, and I have come across a situation a bit over my head.

I have an Excel document with content scattered across multiple cells (inconsistently). I also have a Word document where I've written out individual titles under which I want said data to appear. I have been copying and pasting the content into the word document one cell at a time, which is not only time consuming, but creates a higher margin for error.

Is there an easy and straightforward way to copy cherrypicked data from a massive Excel sheet into exact lines (under individual titles) in a Word document? Preferably at the click of a button! Thank you!

 

[konew1]

If the data goes into a single block in the word document it is easier to collate it somewhere in the excel an then take across the one block.

If the spreadsheet will change and you need to update the word doc then you should paste-link, so you don't have to manually rebuild the word doc every time. This applies even if the data has to go to different places in word, you just need to set up multiple paste-links.