Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Automatic Balance
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Automatic Balance
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
running balance in Excel | Excel Worksheet Functions | |||
options to update automatic links | Excel Worksheet Functions | |||
automatic entering Balance at every entry in my bank account | Excel Discussion (Misc queries) | |||
How do I calculate a running balance? | Excel Worksheet Functions | |||
how : check register running balance is a stationary cell | Excel Discussion (Misc queries) |