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

punk1234567890 · #1 02-20-2022, 11:04 PM

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

macropod · #2 02-21-2022, 03:51 PM

Cross-posted at:
Macro to copy and paste answers from the end of the document
Macro to copy and paste answers from the end of the document
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy selected text from one document and paste to new document in same position on the page	gasparik	Word VBA	1	05-11-2020 05:41 AM
Need Help Creating a Macro To Copy and Paste Info	rsrasc	Excel Programming	0	10-30-2018 09:08 AM
copy a row and paste the row into another sheet more then one time:macro	waqar1239	Excel Programming	1	04-07-2017 09:57 AM
Copy/Paste/LastRow Help with Macro	rsrasc	Excel Programming	1	09-24-2016 01:25 AM
How to do an automation for copy paste, added new row (macro)	jpol	Excel Programming	1	03-01-2013 05:53 AM