![]() |
#1
|
|||
|
|||
![]()
I have a word document listing a series of True/False Questions (up to 49 questions-only included two (2) here for demonstration), and right after all the questions there are the answers to the questions. Please notice the questions are splitted/separated in two line
The way you see the information below is how it is copy and paste it from the source. What I would like to have is to see if there is a way to automate the information with a macro. Here is how the information in the document looks now..... Question #1 (Q6955) Here is the first question. True False Question #2 (Q6954) Here is the second question. True False Question #1 : True Question #2 : False ================================================== ============================ After the macro is applied, here is how the information should looks like: 1. Question #1 (Q6955)-Here is the first question. A. True B. False Answer: A 2.Question #2 (Q6954)-Here is the second question. A. True B. False Answer: B ========================================== Hope someone can help me! Thanks! |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
custom icon, undo/redo for macro, permanent macro | Rapier | Excel | 0 | 08-05-2013 06:30 AM |
How do I assign a macro to a button when the macro is in my personal workbook? | foolios | Excel Programming | 2 | 07-27-2011 02:41 PM |