Thread: [Solved] Sorting Request Help Needed
View Single Post
 
Old 10-14-2015, 01:37 PM
rsrasc rsrasc is offline Windows 7 64bit Office 2010 64bit
Competent Performer
 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default Sorting Request Help Needed

I have a file containing a series of multiple questions with their answers. The sample below have only three (3) questions. As you can see they are listed with a sequential number starting with one but the ACA numbers associated to them are not sorted in sequence.

1. ACA-88026 ......
2. ACA-11001 ......
3. ACA-05560 .....


After applying the macro or code, the output should looks like the one below (also with their associated text):

1. ACA-05560
2. ACA-11001
3. ACA-88026


As always thanks in advance for your support.





Sample text:

1. ACA-88026 Which of the follsosdwing procedures XXXXwoSSSSuld an entity most lSSSSSikely incSSSSlude in its disaster recovery plan?

a. xxxCcocncvcecrctc a.
b. Maintssfadisns sas stsrojan horse program to prevent illicit activity.
c. Devselop an auxiliasfdsssbsrsy sspsty.
d. Stodrse dupsddslsiscsastfes ffdcfof.


Answer: D

Answer (A) xxxx.
Answer (B) xxxx.
Answer (C) xxxx.
Answer (D} xxxx.


2. ACA-11001 Which of the follsosdwing procedures XXXXwoSSSSuld an entity most lSSSSSikely incSSSSlude in its disaster recovery plan?

a. xxxCcocncvcecrctc a.
b. Maintssfadisns sas stsrojan horse program to prevent illicit activity.
c. Devselop an auxiliasfdsssbsrsy sspsty.
d. Stodrse dupsddslsiscsastfes ffdcfof.


Answer: D

Answer (A) xxxx.
Answer (B) xxxx.
Answer (C) xxxx.
Answer (D} xxxx.



3. ACA-05560 Which of the follsosdwing procedures XXXXwoSSSSuld an entity most lSSSSSikely incSSSSlude in its disaster recovery plan?

a. xxxCcocncvcecrctc a.
b. Maintssfadisns sas stsrojan horse program to prevent illicit activity.
c. Devselop an auxiliasfdsssbsrsy sspsty.
d. Stodrse dupsddslsiscsastfes ffdcfof.


Answer: D

Answer (A) xxxx.
Answer (B) xxxx.
Answer (C) xxxx.
Answer (D} xxxx.
Reply With Quote