Thread: [Solved] Need Help Creating Macro
View Single Post
 
Old 10-22-2014, 04:21 AM
rsrasc rsrasc is offline Windows 7 64bit Office 2010 64bit
Competent Performer
 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default Need Help Creating Macro

Hi all,

I have a document with over 75 multiple choice questions but for this example I'm only including three (3) of them. So the questions have the following format (the document lists all the questions firsts and then lists all the answer choices with their explanations)

Question #1 (ACCA.101069REG-SIM)
Mr. Travel is a U.S. citizen who has been a resident of Germany for five years.
A. $0
B. $1
C. $2
D. $3

Question #2 (ACCA.101070REG-SIM)
Mr. Travel is a U.S. citizen who has been a resident of Spain for five years.
A. $0
B. $1
C. $2
D. $3
Question #3 (ACCA.101071REG-SIM)
Mr. Travel is a U.S. citizen who has been a resident of Portugal for five years.
A. $0
B. $1
C. $2
D. $3
"========================"So all the questions ends here(this info here is not part of the document, just want to emphasize the info.

So after all the questions are listed, all the answers to the questions are listed as follows:

Question #1 (ACCA.101069REG-SIM)
A. Incorrect
B. (Correct!)
C. Incorrect
D. Incorrect

Question #2 (ACCA.101070REG-SIM)
A. Incorrect
B. Incorrect
C. (Correct!)
D. Incorrect

Question #3 (ACCA.101071REG-SIM)
A. Incorrect
B. Incorrect
C. Incorrect
D. (Correct!)

So, what I would like to have is a macro that will combine or group the questions and answers together, and will insert the answer choice after letter D with the following format:
ANSWER: A

Therefore, after applying the macro this is how the information should looks like:
Question #1 (ACCA.101069REG-SIM)
Mr. Travel is a U.S. citizen who has been a resident of Germany for five years.
A. $0
B. $1
C. $2
D. $3
ANSWER: B
Question #1 (ACCA.101069REG-SIM)
A. Incorrect
B. (Correct!)
C. Incorrect
D. Incorrect

Ok, this is all for now. Questions, let me know. I hope my request is not confusing.

Thanks all,
Cheers,
rsrasc



Reply With Quote