Thanks for the heads up !

I have attached the sample txt file and the excel file for the workings.
Let me again brief my requirements.

1) search for the word "PAID & WAIT TOTAL". If the tab next to this is 0 need not do anything.. if >=1 then we need need to check for the payment date.

2) If date of payment date is <= 8 networkdays from the date report was generated then we need to get details like fund #, account #, order #.

3) Similary all data needs to be copied. ex if it 2, we need to check for the 2 payment dates.

File contains large volmes and we need to check the whole...

Any quick response will be highly appreciated.

- Sindhuja