Formating data to view better

hi vijanand1279, though it's pretty ungrateful to deal with such sort of tasks I would give it a try, please check attachment, press "Get data" button on Sample Format sheet and select txt file to process.
The code has been polished to process data in the provided txt file correctly though there might be errors on other nearly similar files with different layout

Hi Watersev,

Yes this is really awesome...I tried to run the report and it worked perfect. Thank you so much.

I was trying this to create a macro by recording the steps in excel. But it never worked for me. I think I have to learn other ways to create a macro instead of recording all time.

Thank you....

Originally Posted by vijanand1279

Hi Watersev,

Yes this is really awesome...I tried to run the report and it worked perfect. Thank you so much.

I was trying this to create a macro by recording the steps in excel. But it never worked for me. I think I have to learn other ways to create a macro instead of recording all time.

Thank you....

Help me with the bug....

Hi Watersev,

I tried to run the macro with the new report. But I am seeing some missing items from the original text file attached....I have saved the missing items in the seperate text file attached. Also the first row with 380.41- is actually a credit but it is showing as 380.41 after executing the macro. So any credit entry on the text report is showing as positive (Debit) amount.

Please help on the above bug.

Regards,
Vijay

Hi

Could you check on the above bug and help me. Not sure why some of the items are missing from the original and also the credit amount shows in positive.

Regrds,
Vijay