What should I do??

[JAlandhar 201718]

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

 

[bosco_yip]

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

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

2] See attachment

Regards
Bosco

 

[pecoflyer]

Questions about cracking pwd are not allowed in forums...

 

[Luke M]

Questions about cracking pwd are not allowed in forums...

That's not actually a rule of this forum. @JAlandhar 201718 see reference thread: https://chandoo.org/forum/threads/remove-password.23208/

 

[JAlandhar 201718]

That's not actually a rule of this forum. @JAlandhar 201718 see reference thread: https://chandoo.org/forum/threads/remove-password.23208/

this thing didn't worled

 

[bosco_yip]

Here is the screenshot from the OP at the post #.27 of the below post :

https://chandoo.org/forum/threads/filter-data-to-another-sheet-by-cell-value.38676/:



From the screenshot, it is noted that U15 formula is worked, but why U16 doesn't worked ?

The reason unknown, unless the OP can upload that file to check.

Regards
Bosco

 

[Luke M]

this thing didn't worled

Please be more descriptive; an error occured, you got unexpected results, nothing happened, etc...

 

[JAlandhar 201718]

nothing happened by using this file, I'm uploading the file.. please check and let me know if that worked for you

 

[JAlandhar 201718]

i

Here is the screenshot from the OP at the post #.27 of the below post :

https://chandoo.org/forum/threads/filter-data-to-another-sheet-by-cell-value.38676/:

View attachment 52796

From the screenshot, it is noted that U15 formula is worked, but why U16 doesn't worked ?

The reason unknown, unless the OP can upload that file to check.

Regards
Bosco

can't upload this file, it is of more than 10 mb, you can access my team viewer for furthur

 

[JAlandhar 201718]

Please be more descriptive; an error occured, you got unexpected results, nothing happened, etc...

Sir, I need to clear more queries regarding this, can you please explain me each thing??

Should I open a new thread or I have to post in this only

 

[JAlandhar 201718]

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

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