I want in RESULT sheet show the clients calculation as I put in requirement sheet .
in SH sheet the PAID word in column E will put amount in column D(DEBIT) by brings from the lastrow in column I , the NOT PAID word in column E will put amount in column E (CREDIT) in RESULT sheet by brings from the lastrow in column I .
in WS sheet the PAID word in column E will put amount in column E(CREDIT) by brings from the lastrow in column I , the NOT PAID word in column E will put amount in column D (DEBIT) in RESULT sheet by brings from the lastrow in column I .
in RS sheet the PAID , NOT PAID wordS in column E will put amount in column E (CREDIT) in RESULT sheet by brings from the lastrow in column I .
in TR sheet the PAID , NOT PAID wordS in column E will put amount in column D (DEBIT ) in RESULT sheet by brings from the lastrow in column I .
and will brings the NAME and DATE.
there is two formulas for each name and sometimes one formula in column E in RESULT sheet as I did it .I put some clients to see how should calculate.
in column C should merge sheet name ,INVOICE NO and CONDITION for each sheet.
should clear data in RESULT sheet from row2 before gettingf data. also I would make the old date is priorety across sheet for the same client and sort clients from A-Z andd fill mpty cells by hayphen or cells contains zero even if it contains formula .
Last thing exclude SL ID sheets from my requirements
I hope to use sorting way to deal with big data in future( 6000 rows for each sheet)
Bookmarks