+ Reply to Thread
Results 1 to 2 of 2

How to create a report in Word which takes its some specific sentences from excel

  1. #1
    Forum Contributor
    Join Date
    01-08-2013
    Location
    ankara
    MS-Off Ver
    Excel 2010
    Posts
    134

    How to create a report in Word which takes its some specific sentences from excel

    Hello Everyone,
    I'm a referee and solving different cases each time with mathematical calculations in excel. I have created all the sentences and tables in excel and then copy/paste my findings into my word report file.
    I have a specific directory for each case in which I keep my related excel and word files.

    I wanted to know that how can I automatically export my sentences from excel to word's related location.

    For example:
    I have an excel file named as case001.xlsx and there are certain cells with text info such as in sheet1: A1, B77, C5 in sheet2: D5

    Then I want to have a word template in which I will define and locate case001.xlsx and it will automatically create the following report:

    I.INTRODUCTION
    case001.xlsx!sheet1!A1

    II. THE CASE
    Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Maecenas porttitor congue massa. Fusce posuere, magna sed pulvinar ultricies, purus lectus malesuada libero, sit amet commodo magna eros quis urna.
    case001.xlsx!sheet1!B77
    case001.xlsx!sheet2!D5

    III. RESULT
    case001.xlsx!sheet1!C5

    I will appreciate any help!
    Thank you very much.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: How to create a report in Word which takes its some specific sentences from excel

    Provided your Excel workbook is laid out appropriately (e.g. all the data for a given letter on a single row), you could use a mailmerge.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA to create a "note" or a few sentences based on specific cell values.
    By Nerfmagnet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-07-2016, 02:31 PM
  2. Smart way to create a standard Word Report with Excel data (Bookmarks?)
    By Nbisgaard in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2016, 08:36 AM
  3. Replies: 5
    Last Post: 07-31-2014, 12:51 PM
  4. Find a requested word within sentences and output those sentences elsewhere
    By swfred2000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-19-2014, 02:24 PM
  5. [SOLVED] Formula that takes takes out a specific word/number from text string
    By ncalvelo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-29-2012, 10:21 AM
  6. Create sentences in Excel
    By zsemago in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-24-2011, 06:31 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1