PDA

View Full Version : Macro to copy and paste answers from the end of the document



punk12345678
02-20-2022, 11:28 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
02-21-2022, 03:51 PM
Cross-posted at:
Macro to copy and paste answers from the end of the document (msofficeforums.com) (https://www.msofficeforums.com/word-vba/48537-macro-copy-paste-answers-end-document.html)
Macro to copy and paste answers from the end of the document (excelforum.com) (https://www.excelforum.com/word-programming-vba-macros/1371865-macro-to-copy-and-paste-answers-from-the-end-of-the-document.html)
Please read VBA Express' policy on Cross-Posting in Rule 3: http://www.vbaexpress.com/forum/faq.php?faq=new_faq_item#faq_new_faq_item3

arnelgp
02-22-2022, 04:48 AM
is there a "good" solution provided on those "cross-posted" forums?
if there is such thing as cross-posting, can there be a case for cross-answering, coz on
all those forums you are there also, trying to block any answers to the OP.

to the OP there is a program call SchoolhouseTest.
you can export your questionnaire (and the answer)
to Aiken text format that you can import to LMS services
such as Moodle.
29439

macropod
02-22-2022, 02:39 PM
on all those forums you are there also, trying to block any answers to the OP.
Kindly don't lie about my posts here and elsewhere...

punk12345678
02-22-2022, 11:59 PM
Thank you, Arnelgp. Really appreciate you taking time out to respond with screenshots. I will try it out.

Sorry about the cross-posting, I was not aware of the clause.

- Sam

Aussiebear
02-23-2022, 12:22 AM
Sorry about the cross-posting, I was not aware of the clause.

- Sam

Well Sam, that statement of yours is somewhat unbelievable. Everyone of those forums you posted in all have the same or very similar rule about cross posting. What people like you don't understand is that the VBA community is quite small and members here are often members elsewhere. Any post could quite well be noticed across many forums, and in this case you have been found to be less than truthful. Its your reputation but right now its not that well regarded.

Aussiebear
02-23-2022, 12:28 AM
This thread is now closed.