View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve the Pirate Steve the Pirate is offline
external usenet poster
 
Posts: 1
Default New project - Exam question bank with export to Word

I have an excel spreadsheet which holds our entire multiple choice exam
question database. At the moment creating a 50 question exam paper in Word to
print off for students is a lengthly process, involving pasting each Catagory
Title, Question and the three possible answers into a Word template.

What I would like is somthing that allows me to select a radio button for
each of the questions I would like to appear in the exam and then export that
data into the required parts of a template at the touch of a button. Am I
asking too much?

I was thinking maybe a macro? Unfortunately I have very little macro
experience, but am keen to learn. If anyone can point me in the right
direction I'd really appreciate it.

Thanks for your time,

Steve