Should be doable with drop down boxes. Or, you could goto your list and
select each one and then copy/paste the selected rows..

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve the Pirate" <Steve the wrote in
message ...
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