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.