Hi All,

Here is my requirement..!

I generally download a .txt file (large file) from where i need specific informations.

I find for a specific word and in the next tab there willl be count. If count is 0 we need not do anything.

If it is >=1 then we need to check for the payment date and if date is =< 8 networdays days then the fund , account, trade details needs to be copied in a seperate work sheet.

Am not sure whether this can be done using macros.
if possible do we use excel or txt file itself as i am new to VBA.

Please help me out in this and this is really a large data and it takes long time to finish off the task....

Any suggessions will be highly appreciated !

- Sindhuja