Search, concatenate, move, then delete

[dguenther]

Hi,

I am trouble doing the following in a macro:

OUTCOME: The court reversed the judgment of the district court. The court
remanded the question of the amount of costs to the district court for a further
remand to the arbitrators to make an appropriate award.
JUDGES:
*** [...***1] Joseph F. Baca, Justice. Dan Sosa, Jr., Chief Justice, Richard E.
Ransom, Justice, Kenneth B. Wilson, Justice, concur. Seth D. Montgomery,
Justice, Concurring in part, Dissenting in part. ...
2 of 27 DOCUMENTS
State v. Ybarra
No. 18,506
SUPREME COURT OF NEW MEXICO
111 N.M. 234; 804 P.2d 1053; 1990 N.M. LEXIS 415
November 28, 1990, Filed​

I need excel to:

(1) search for judges in the first row
(2) concatenate everything in the row(s) after judges and before the next line that starts with a number.
(3) move concatenated rows to G1
(4) delete "judges" and everything before it EXCEPT row 1



Thanks if you can help.

 

[dguenther]

Hi Rick,

I think between you and Sektor's code, I have got what I need for this portion of my project. The two of you have saved me literally days or weeks of time.

If you are up for a REALLY tough challenge, I have the need for a final chunk of processing that goes on after your code is run:

http://www.mrexcel.com/forum/showthread.php?t=558668


I sincerely thank you for all of your help on this!!

Danny