+ Reply to Thread
Results 1 to 1 of 1

Pull Excel Data into Word Content Controls

  1. #1
    Registered User
    Join Date
    12-23-2020
    Location
    DFW, Texas
    MS-Off Ver
    Office 365
    Posts
    11

    Pull Excel Data into Word Content Controls

    Greetings,

    It seems this has been answered many times but I cannot for the life of me apply the VBA to what I need. It doesn't help that I don't understand VBA much, so please be gentle with any instructions

    Problem: I have an excel file that I extract data to monthly, manipulate the data into tables, pivot tables and graphs, and then write a report "interpreting" the data. The interpreting is mostly just repeating the data in many different forms.

    Solution: I'd like to pull excel data from various sheets into the content controls of my word template, so that it will auto populate my report.

    Variables: There are a different amount of trends to analyze each month. My thought is to pull a max amount, have the rest fill in as blank or N/A or something and just delete the remaining.

    The example excel file has 4 sheets. Sheet 1 is the raw data. Sheet 2 is Where some of the data is pulled from (F2/F3/F5/F6 are all #s I use), and sheet 3 is where the rest of the data is located. For simplicity I could create a Sheet 4 each time that organizes the Sheet 3 more easily. In sheet3/4 I need to get the Trend names (ABC/CDE, etc) and the values. The Grand Total Value can be pulled but it will likely not be utilized as the same number is found in sheet 2 and seems more likely to be easily used.


    The example word template has some content controls not pulled from the excel file, and some that should be. Total, Trends, Open/Closed and their related content controls are where the excel file data needs to be pulled to

    Sheet 2, F3 => Total
    Sheet 3 or 4 => Each Row = Trend label and Trend #
    Sheet 2, F5 and F6 => Open/Closed

    Feel free to ask any questions. I hope I covered the gist of it. Thank you in advanced!



    Edit:

    I tried mail merge and it doesn't truly do what I want. Even if I get all the data to display on the same page, part of the issue is the variability.

    I also tried the following code with very little luck (uploaded document does not have "Range" set)

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by OdysseusX; 07-06-2021 at 01:31 PM. Reason: Updated with attempt's at fixing.

+ 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. Replies: 1
    Last Post: 04-22-2020, 08:09 AM
  2. Pull data from Word to Excel help
    By beila00 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2016, 10:06 PM
  3. Pull data from Excel into a formatted word Doc, Is it possible?
    By ervinr82 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-24-2015, 12:18 PM
  4. excel data content into a variable in a word table format
    By komp.serve in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2015, 03:54 PM
  5. [SOLVED] Pull data to Word control content from Excel spreadsheet
    By coopman64 in forum Excel General
    Replies: 2
    Last Post: 06-30-2014, 10:05 PM
  6. How to pull out data from Excel into WORD 2007?
    By toplisek in forum Excel General
    Replies: 3
    Last Post: 10-14-2013, 03:58 PM
  7. Replies: 0
    Last Post: 07-02-2013, 08:40 AM

Tags for this Thread

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