HI ExcelForum Geniuses.

I am trying to scan through 200000+ (in a single coloumn all messed together) rows of data and return a four digit number every time it find the words "*REQUEST ID*" in the CELL. The Four digit number is in the same cell as the word REQUESt ID.

So the data looks like this:

1COMPANY ID: JET
REQUEST ID: 7991
DATE OF RQ: 13005
TIME OF RQ: 0719
SIGNATURE : ZKZQF
FLIGHT LEG RECORD:
"0101REC AIRCOM-ZK-ZQF/RTE LEPAR WPT YB 39.142S 150.276E.-MEL AKL CMP A04-.NZAA APT/ACFMT PWI/LC 9/ETD 0719/FLT 0133/WX
FL 360/ FPFL1
0R h 0
5 88øænTy “ 0 1< 8q 0QD`þnT¦« ÀQ 9 ÿÿÿðn
T¦¿ DÖ±
TIME_IN_TO_APPN: 071919
TIME_OUTOF_APPN: 071919
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

COMPANY ID: QF
REQUEST ID: 2503
DATE OF RQ: 13022
TIME OF RQ: 0327
SIGNATURE : MFARE41B
FLIGHT LEG RECORD:
#0101REC WSSS-YSSY/RESP T/SUM/ACCRZ 100/RF/RF/RFF/RFFR 100/SHTWD/SHTAD/VFR NODPA/NOETP/ETD 1150/TORWY 02C/AC OQE/ZFW 36
00/360/ FPFL1
0R h 0
5 88øænTy “ 0 1< 8q 0QD`þnT¦« ÀQ 9 ÿÿÿðn
T¦¿ DÖ±
SEGMENT NOT FOUND
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

COMPANY ID: QF
REQUEST ID: 2547
DATE OF RQ: 13022
TIME OF RQ: 0359
SIGNATURE : MFJBY43C
FLIGHT LEG RECORD:
#0101REC YPPH-YSSY/ETOP Y/ACFMT LSP/TAXIN 07/SHDGF 01/TAXOT 11/SHDGT 02/MAXFL 410/MINFL 260/PL 0244/FLTYP D/PER D/SC 4/
ACCLB CI40R1/ACCRZ CI40 CI60 CI80 CI100 CI125 CI150/EODO 1.05/IUSR2 582/TRIP 222/AC OGO/CAPT GOLDING/DIS JAMIE BAYLISS/E
TD 0535/STD 0535/STA 0950/BLOX 0415/POB 198/STLD Y/STPLD 450/ARRFT 00/ARRFF 00/RESP P/SUM/TNKC -99/PSEC N/FLT 582/ATCI N
/SSEC NO/DNC 27621/ 88øænTy “ 0 1< 8q 0QD`þnT¦« ÀQ 9 ÿÿÿðn
T¦¿ DÖ±
TIME_IN_TO_APPN: 035951
TIME_OUTOF_APPN: 035956
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


Every time there is a row of XXXXXXXXXXXXX it is a new record. This is just a dump of data I need to analyze in a .txt document. it is all pasted in the same coloumn but each line is on a different row.

The above dump is on Sheet2. In Sheet1 I can pull out the first REQUEST ID by using the formula:

=IF(ISNA(MID(INDEX(Sheet2!$A:$A,MATCH("*REQUEST ID*",Sheet2!$A:$A,0)),26,4)),"",MID(INDEX(Sheet2!$A:$A,MATCH("*REQUEST ID*",Sheet2!$A:$A,0)),26,4))

and I can pull out the first Company by using the formula:

=IF(ISNA(MID(INDEX(Sheet2!$A:$A,MATCH("*COMPANY*",Sheet2!$A:$A,0)),26,4)),"",MID(INDEX(Sheet2!$A:$A,MATCH("*COMPANY*",Sheet2!$A:$A,0)),26,4))

What I need to do is have a formula for this messy data that if I copy the above formulas down it will return the subsequent REQUEST ID on each row as I copy down.

Is this possible?

I have dabbled in VBA a very little bit in the past but not enough to create any solution that could help me.

Please help


p.s. the data is messy with many "artifacts" and btis of font that make no sense. Its an issue with working with such an old system.

I am using Excel 2010 btw.