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
Bookmarks