View Single Post
 
Old 02-20-2022, 11:04 PM
punk1234567890 punk1234567890 is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2022
Posts: 1
punk1234567890 is on a distinguished road
Default Macro to copy and paste answers from the end of the document

Dear Friends,

Need your help with a suggestion for a macro to copy and paste answers from the end of the document to the end of the relevant question. I have around 200 such questions in a document and it would be great if any one could suggest a macro or any solution for this. I am not good at programming hence need your help with this. Any help would be greatly appreciated. The structure of the document is as follows.

MY DOCUMENT CONTAINS QUESTIONS AT THE TOP AND ANSWERS AT THE END AS FOLLOWS:

Q1
Summer is very hot.

a. Summer
b. Very
c. Hot
d. Is


Q2
The moon looks so beautiful.

a. Looks
b. Moon
c. The
d. Beautiful
.
.
.
.
.

Answers:
1. a - Summer
2. b - Moon
.
.
.
.

OUTPUT FROM THE MACRO SHOULD COMBINE THE QUESTION AND THE RELEVANT ANSWERS AS FOLLOWS.

Q1
Summer is very hot.

a. Summer
b. Very
c. Hot
d. Is

Answer: a
Summer

Q2
The moon looks so beautiful.

a. Looks
b. Moon
c. The
d. Beautiful

Answer: b
Moon



Thanks,
Sam
Reply With Quote