Integrating Excel and Word

ECB

Board Regular
Joined
Mar 3, 2009
Messages
53
Office Version
  1. 365
Platform
  1. MacOS
  2. Mobile
Hello there,

I hope this finds you all well. I'm back again, and I was hoping for some advice.

As part of my work, I produce reports in Microsoft Word. Maybe about 30 pages long, largely the same text information, with an amount of financial information pulled across from a default spreadsheet. Currently this is done by copy and paste. In essence though, I'm working with a default word document and a default excel document.

What I'd like to do is link the excel document and the word document so that once the excel spreadsheet is complete, it auto populates the word document.

I want to be able to insert specific cells, but also pivot tables into the reports.

I think from my understanding that this is theoretically possible - but is it practical? And what are the possible shortcomings of this approach rather than say copying and pasting the relevant information?

Thanks for any pointers,
B
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
56,916
Office Version
  1. 365
Platform
  1. Windows
This sounds like a prime candidate for a Mail Merge.
If you Google "Mail Merge between Excel and Word", you will find lots of articles and tutorials that should help you through it.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,560
Messages
5,637,060
Members
416,955
Latest member
Gohar hussain

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
Top