Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel - Multiple Linked Worksheets inserted in Word

Status
Not open for further replies.

Serendipiter

Programmer
Jun 22, 2010
18
US
I need to teach somebody without a lot of computer experience how to insert cell ranges from 4 different Excel worksheets (within the same workbook or not) that have linked cells between the worksheets into a Word document such that the worksheets in the Word document will all update when there are any changes to the Excel worksheets.

He needs to repeat this on a regular basis, each time starting with a new Word document. I'm looking for the shortest amount of steps (or templates) so that he doesn't have to perform many steps other than changing the text in the Word document and data in the worksheets.

Can you come up with a way to do this with as few steps as possible or with templates?
 
I was being fairly facetious when I simple said, "macro." Your requirement seems much more varied than a single macro might encompass. However, you might want to design several, each performing a related series of steps in order to simplify the process.

But as I was thinking about this kind of request, my thoughts went back to a time when I supported several departments. One had a new fellow that was hired to analyze build schedules and work with the shop to expedite problems. He called me several times to discuss how to use his Excel toolbox. He just didn't get it. Nice guy. We talked about woodworking and fishing. But no matter how many times I explained what I thought was really simple stuff, it never clicked. He ended up getting a job in the shop, liking it and doing a better job!

Some seed fell on the wayside...
Some seed fell on a rock...
Some fell among thorns...
And others fell on good ground, and grew up and yielded a hundredfold.

IMNSHO, a step by step for a non-Savvy user? You'll be hand holding more than you intend.
 
Thank you for the responses. The person that I'm helping is trying to increase his work efficiency by using some advanced (at least advanced for him) features of Excel and Word. He has his own small business. He is the only employee; he is not an experienced computer user and he can't afford to hire an experienced computer user. I was hoping that somehow I could make this process, explained in my original post, easier for him, but I haven't come up with a simple method even with multiple macros (especially since macros don't check for a starting "state"; meaning they can be executed when they're not supposed to be executed; they're often not foolproof).
 
Hey, you get what you pay for!

Of course, this is a "tip" site and I gave that my best shot.

If you run into some part of your help for him that you need a tip, well this is the place to come!

The gist of what you've disclosed regarding his "system," leads me to suspect the manner in which he's using his MS Office suite. Just a gut feeling from 25+ years dealing with spreadsheets, people & business applications.

Maybe you could explain what the 4 different ranges are and why they are embedded into a Word document? Perhaps we can help him in a different, hopefully better way.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top