Dear Macro Gurus,

I'm trying to explore some fixed length file and extract data based on certain key conditions. I managed to get the required information from the flat file. But now i need to group it and make another report out of it.!

Here is my data,

File Name Debit Amount Credit Amount
CPUA0001.079 ----- 11412.38
CPUA0001.076 ------ 1202.19
CPUA0001.076 1202.19
CPUA0001.076 1202.19
CPUA0001.076 1202.19

Now I need to group these against the file name and get the total debit and total Credit. Something like below in a seperate sheet.

Unique Filename Total Debit amount Total Credit Amount.
CPUA0001.079 XXXXX XXXXX
CPUA0001.076 XXXXX XXXXX

Please help me to achieve this! Thanks a lot.
Do let me know if you require any other info