LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Zygy
 
Posts: n/a
Default 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?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
running balance in Excel Dan Connors Excel Worksheet Functions 5 April 3rd 06 08:11 PM
options to update automatic links Werner Rohrmoser Excel Worksheet Functions 0 November 10th 05 12:58 PM
automatic entering Balance at every entry in my bank account Sena Excel Discussion (Misc queries) 2 August 10th 05 05:44 PM
How do I calculate a running balance? Susan Excel Worksheet Functions 1 July 29th 05 03:22 AM
how : check register running balance is a stationary cell Michele Excel Discussion (Misc queries) 9 January 19th 05 05:25 PM


All times are GMT +1. The time now is 06:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"