I used to generate lots of MCQ question papers for our class, with four options to select the correct options viz. (a), (b), (c), (d).



I need a macro to collect the right answers marked in red colour and paste at the end of the documents with a title "Answer Key" in table form consisting of serial number of the above questions. I also need a code of the selected answer changes to reflect in the answer key table also.

Thanks and regards
NA Hariharan