![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
rsrasc | Excel Programming | 1 | 09-24-2016 01:25 AM |
![]() |
jpol | Excel Programming | 1 | 03-01-2013 05:53 AM |