Macro to copy and paste answers from the end of the document

**punk1234567890** · 02-20-2022, 11:29 AM

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

**Squeaky** · 02-21-2022, 12:16 PM

Hi Sam,

I took a second look at your post and it looks to me that next to the "answer" someone will place a letter and the answer will populate. In the answer cell you can write the formula =if(d2="","","Moon") or =if(d2="","",A500) assuming the letter answer is in cell D2 or the answer word is in cell A500. So after any input the answer will display. Problem is you would have to build every answer and 200 is a lot. In place of A500 you may be able to write a vlookup formula but I would need to know the structure of how and where the answers are written in. Can you post the sheet?

**punk1234567890** · 02-21-2022, 01:48 PM

Hi Friend,

Thank you for the response. I am sorry I forgot to mention that it is an MS Word document and not an Excel sheet.
I am looking for an MS Word macro to solve the above. The format of the document is exactly as above, just with many questions. Hope this clarifies. thanks.

Sam