Hi Guys,

I'm trying to come up with a macro program to get the Sequence no. (in
bold font) and write it in column C. In Colum A I have the data below,
In Column B I have the Incident number and In column C i wish to write
the extracted nubmers from Column A. I was thinking that the word
Sequence no. can be used as a search item so that excel will know that
the number below it is the number that needs to be written on column
C.

I hope you can respond to this i have been working for hours to get
this running but I haven't really got any success so far.

Thanks in advance.


Description
Vendor/Supplier:XXXXXXXXX
Invoice no.
Sequence no.
10024350
10024370
Vendor/Supplier: XXXXXXXXXX
Invoice no.
SKU/PLU No. 8888010101618
8888010101601
Sequence No.
13016989

Vendor/Supplier: XXXXXXXXXX
Invoice No.
Sequence no.
3036940
Product code No. 1256453119465
Qty: 24
Vendor/Supplier: XXXXXXXXXX
Credit note. CN126140
Sequence no.
25022191

Vendor/Supplier: Diethelm Singapore
Credit note. 1950201830
Sequence no.
13016989


--
Eladamri
------------------------------------------------------------------------
Eladamri's Profile: http://www.excelforum.com/member.php...o&userid=35099
View this thread: http://www.excelforum.com/showthread...hreadid=559205