Hi All

  i want to know is any algorithm available to this  process...

my source file is excel. it has 3 columns cardno, debit, credit

i hav to check the credit must b equal to debit...eg

   card no credit debit

    12 230 100
    12 130

    45 250 350
    45 100

the file content will b like this. i hav to find both credit and debit which are tallying. and seperate those records in new fiel...

so to check this with the combinations is there any algorithm available?

pls let me know..


advance thanks

Violet

Hi,
I've moved this into the VBA section as it's not really a general problem, more specific to Excel.
Regards,
Kieron
PS. I would suggest that you upload a file containing simillar workbook and we'll sort out the code for you; or tips, anyway! :-)


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)