theDude-

Thank you so much!! This is fantastic! You've saved me a lot of work i
FileMaker. And thanks for including all the comments--they're a grea
learning tool.

One little thing I noticed after running the macro is that rows wit
nothing in the "Answer Key" column get returned with an ending comma
e.g.:

apples, p. 1,

If I study the code for a while (long while), I think I should be abl
to remedy that...but in the meantime, if you're able to help (onc
again), that'd be great.

Thanks again!



theDude Wrote:
This macro should work for you:

Hope this helps,
theDud

--
marle
-----------------------------------------------------------------------
marlea's Profile: http://www.excelforum.com/member.php...fo&userid=2620
View this thread: http://www.excelforum.com/showthread.php?threadid=46715