#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
copy and paste, macro |
|
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 |