Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 09-11-2016, 05:22 AM
Tom Saylor Tom Saylor is offline Exporting multiple data sets from a single Word Form into Excel Windows Vista Exporting multiple data sets from a single Word Form into Excel Office 2007
Novice
Exporting multiple data sets from a single Word Form into Excel
 
Join Date: Sep 2016
Posts: 6
Tom Saylor is on a distinguished road
Default

It’s a long story, Graham. I work for a major educational testing company, developing all sorts of standardized tests, often consisting of multiple-choice questions (which we in the industry call “items”). For reasons all their own, a particular client wants batches of items delivered in an Excel sheet, one item per row. But the spreadsheet format (with items horizontally arrayed) is not at all congenial to the test development process. For that you need to have the items vertically arrayed in more or less the same way they’ll appear on the test and in a form that allows easy review and editing, and you want to have multiple items gathered into one document so that you can move readily from item to the next during the review process, resequence the items if necessary, and easily send all the items together from place to another. So for item development purposes, a Word file containing multiple items seems the most convenient option. The challenge I’m facing is to find the most convenient way to convert such a file to Excel format. You and others here have been a tremendous help. Thanks!
Reply With Quote
 

Tags
export content data, vba macro



Similar Threads
Thread Thread Starter Forum Replies Last Post
merging data sets in excel 2013 nwiabrad Excel 9 07-24-2014 12:07 AM
Export data from multiple attachments into a single excel document Woolstar Outlook 0 12-07-2011 09:49 AM
Exporting multiple data sets from a single Word Form into Excel Copying Multiple tables from excel into a single word document dineshtgs Word Tables 1 04-07-2011 01:27 AM
Exporting multiple data sets from a single Word Form into Excel How can I break a single group of words into three sets? Learner7 Excel 1 03-22-2011 02:35 PM
Exporting multiple data sets from a single Word Form into Excel moving data from single to multiple columns? mzimmers Excel 3 08-23-2010 08:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft