• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

What should I do??

I need a help again,

the formula works good when there is a entry in debit column(in pic1 ending with .26), but when I change the value in credit cell, the error occurs(pic 2 : ending .39)



and I need help in other file, can i crack the VBA password in excel sheet
 

Attachments

  • Screenshot 2018-06-03 13.41.26.png
    Screenshot 2018-06-03 13.41.26.png
    61.6 KB · Views: 7
  • Screenshot 2018-06-03 13.41.39.png
    Screenshot 2018-06-03 13.41.39.png
    53.1 KB · Views: 4
upload_2018-6-4_17-40-47.png

1] As per attached file, in F7, formula copied down :

=IF(B7="","",IF(D7<>"",F6+D7,F6-E7))

2] See attachment

Regards
Bosco
 

Attachments

  • SumBalance.xlsx
    55 KB · Views: 3
nothing happened by using this file, I'm uploading the file.. please check and let me know if that worked for you
 

Attachments

  • EWB_Preparation_Tool (1).xlsm
    223.1 KB · Views: 4
In Vou file, there is a sub ledger column
which have 0,1,2 values in it
1 stands for the CDS sheet, whereas 2 stands for LOAN sheet
I need to bifurcate data according to it, as presently I get all the data in LOAN sheet

***********************
 

Attachments

  • A&A - Copy.xlsm
    612.3 KB · Views: 7
Back
Top