Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse by Tags

  • Creating Word reports from Excel

    If you create regular Word reports from Excel, how would you like to be able to produce each report with just one click, instead of manually copying and pasting all the tables and charts from Excel to Word? I've written an Excel utility to do this automatically. The principle is quite simple - the program looks at all the bookmarks in the Word document. If any of their names start with "tag_", the program looks for the range or chart in Excel with a similar name, and copies it across...
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.