Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-15-2014, 05:19 AM
rsrasc rsrasc is offline Looking for Help to Create a Macro (Sort) Windows 7 64bit Looking for Help to Create a Macro (Sort) Office 2010 64bit
Competent Performer
Looking for Help to Create a Macro (Sort)
 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default Looking for Help to Create a Macro (Sort)

Hi all,



I have a document with a list of multiple choices with their answers (See sample below).


1. Under the NIA of the UCCA, let’s do the following:

a. Nothing

b. Do nothing

c. Do nothing nothing nothing

d. Do something


Answer (B) is correct. Under the NIA of the UCC….
Answer (A) is incorrect. Under the NIA of the UCCA…
Answer (C) is incorrect. Under the NIA of the UCCA…
Answer (D) is incorrect. Under the NIA of the UCCA…

As you can see the order of the answer choices sometimes (in my document) is not listed in the right order (a, b, c, and d)


What I'm looking for is a macro that will sort the answer choices automatically in the following order:

Answer (A) is incorrect. Under the NIA of the UCCA…
Answer (B) is correct. Under the NIA of the UCC….
Answer (C) is incorrect. Under the NIA of the UCCA…
Answer (D) is incorrect. Under the NIA of the UCCA…


Therefore, the final output will be something as follows (the question followed by the answer choices in alphabetical order):


1. Under the NIA of the UCCA, let’s do the following:

a. Nothing

b. Do nothing

c. Do nothing nothing nothing

d. Do something


Answer (A) is incorrect. Under the NIA of the UCCA…
Answer (B) is correct. Under the NIA of the UCC….
Answer (C) is incorrect. Under the NIA of the UCCA…
Answer (D) is incorrect. Under the NIA of the UCCA…

Your assistance is appreciated.

Thanks in advance for your great support.

rsrasc
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for Help to Create a Macro (Sort) Macro to create list of acronyms lsmcal1984 Word 3 09-04-2013 07:33 AM
Macro to conditionally create or go to worksheet Reinaldo123 Excel Programming 1 07-06-2012 07:23 AM
Sort table using macro saslotteroy Word VBA 2 09-15-2011 02:41 PM
Looking for Help to Create a Macro (Sort) Generic range for custom sort macro? tswiers Excel Programming 2 08-11-2011 02:40 AM
Create Custom menu using a macro twnty2 PowerPoint 0 06-29-2011 04:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft