On one of my worksheets I have in Col. E Debits, Col.I Credits and in Col.L
the Balance for which I created a calculation formula and when I add an
additional line to make unforeseen entry in between existing ones, to get
the balance of the Dr. and Cr. entries I have to Copy and Paste the
formula. Is there a way that the formula I created to get the balances in
Col.L will be automatically applied once entries have been made in Col. E
and I?

Simple solution :


Why don't you cretae an empty entry line somewhere in yoiur sheet. If you
want to insert a new entry, select the empty line, copy it, go to the place
where you want to insert the entry and do Insert copied cells. Of course
this is only an improvement if you record a macro that will do this for you
and assign it to a command button.

hth







"Zygy" wrote:

> On one of my worksheets I have in Col. E Debits, Col.I Credits and in Col.L
> the Balance for which I created a calculation formula and when I add an
> additional line to make unforeseen entry in between existing ones, to get
> the balance of the Dr. and Cr. entries I have to Copy and Paste the
> formula. Is there a way that the formula I created to get the balances in
> Col.L will be automatically applied once entries have been made in Col. E
> and I?
>
>
>