help write macro instead of formula summing and subtracting between debit & credit

[leap out]

hello i try write macro in worksheet change event but doesn't work
I would when e5 is filling value then should the formula dynamically like this from the firs time in f8=e5+d8-f8
then should this formula in column f after rows 8 in column f
f9=f8+d9-e9

[jindon]

Are you sure about this?

i would when e5 is filling value then should the formula dynamically like this from the firs time in f8=e5+d8-f8
then should this fromula in column f after rows 8 in column f
f9=f8+d9-e9

If it suppose to be E8, then
F7:
=IF(COUNT($E$5,D8:E8)=3,E5+D8-E8,"")
F8 to the last row that you want
=IF(COUNT(G8,D9:E9)=3,G8+D9-E9,"")

Or am I missing something?

[leap out]

yes I made mistake the formula in first time should f8=e5+d8-e8
I don't need column g I write in it some notes by text the values in column d,e,f do you see the formula in my file in f8,9,10 the rests of the values in column f should the same thing like f9,10

[jindon]

Correction

F8:
=IF(COUNT(E5,D8:E8)=3,E5+D8-E8,"")

F9: down
=IF(COUNT(F8,D9:E9)=3,F8+D9-E9,"")

Also E5:
=IF(COUNT(B5:D5)=3,B5+C5-D5,"")

[leap out]

yes your formulas works perfectly , but as my post topic I would do that by macro I don't want pull down the formula every time I need it I would do that directly when put the values begins from d8:f I try writing code but i failed if you can do that I appreciate that

[jindon]

Still I don't understand why you need this though...

Please Login or Register  to view this content.

[leap out]

thanks very much for this code if it's possible I don't show the formula the idea I don't want press in cells contain formula may be happens some problem if mod the formula an I don't want protect the cells or formula
and every time I have to unprotect to enter data that
I would the code work every thing and if want you understand this way of account this way like account list bank follows the balance every process how changes

[jindon]

If you want to prevent user from changing the cells, you need to protect the sheet/cells anyway.

Why not protect the sheet and lock only the cells with formula?
In other words, unlock only the cells that you want user to edit?

[leap out]

you're extremely right ! just I thought may be way do that hide formula by code without using protecting
many thanks for your assistance whether code or formula I would just understand the value 3 in formula may you explain me what means ?
thanks again