+ Reply to Thread
Results 1 to 3 of 3

make word file from excel data

  1. #1
    Registered User
    Join Date
    08-30-2010
    Location
    Gent, Belgium
    MS-Off Ver
    Excell 365 (1908)
    Posts
    7

    Question make word file from excel data

    I have many test for my students in Word. Every time i make a new and copy and paste some questions. This is a very time consuming proces. I want to make a database of test questions in Excel. Every time I have to make a new test I would like to select certain questions from my Excel list (according to difficulty, grade ...) and convert the selected questions to a test in Word into a certain lay-out (header, every question a number ...). Is this possible?

    Thanks in advance

    Hans

  2. #2
    Registered User
    Join Date
    04-26-2020
    Location
    Massachusetts
    MS-Off Ver
    Office 365
    Posts
    93

    Re: make word file from excel data

    Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you
    have removed any private information, remember this is a public forum and so available to anyone.
    We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

  3. #3
    Registered User
    Join Date
    02-14-2020
    Location
    AMsterdam, Netherlands
    MS-Off Ver
    365
    Posts
    78

    Re: make word file from excel data

    I think that would be possible an extra added sheet to your workbook.

    Sheet 1 has all questions.
    In sheet 2 you create a fixed format, depending on your excel skills, theres more ways to fill the Excel. (dropdown, vlookup)
    (Fixed formats are far from ideal though, one question has large text, others smaller.)

    Technically achievable? Yes
    Easy and timesaving? Not sure, as Excel isnt really suited to be a word-processor; you might end up having to spend much time on lay-out on every file.
    (Before a you get a reasonable print-out.)

+ 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. how to transfer data from Excel file to Word file as per requirement
    By roofi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-25-2014, 01:39 AM
  2. Macro to make new word doc file on excel creteria.
    By visha_1984 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2013, 06:14 AM
  3. macro to take data from tables in word file to excel file
    By sandbach in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2010, 05:02 PM
  4. macro to take data from tables in word file to excel file
    By sandbach in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2010, 12:19 PM
  5. Can I make a database in Word with Excel Data
    By Myn777 in forum Excel General
    Replies: 5
    Last Post: 12-12-2005, 05:30 PM
  6. [SOLVED] HOW TO MAKE A EXCEL & WORD FILE IN RECOGNIZABLE FORMAT
    By SHAHZAIB ISMAIL in forum Excel General
    Replies: 3
    Last Post: 11-18-2005, 01:45 PM
  7. Replies: 0
    Last Post: 11-03-2005, 08:10 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