Find for a specific word and extract details based on the found value
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.:doh:
if possible do we use excel or txt file itself as i am new to VBA.
Please help :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