View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default having items posted in one worksheet appear in another

hi,
it is possible. i have my personal check book in excel. there is a number of
ways to do it. mine is set up like this.....

index, check#, date, deposit, checkamt, runbalance, comments, notes.
for the running balance, you will need the following formula in column F....
=IF(E4="",F3+D4,F3-E4)
In this example, column E would be the check amount. column D would be the
deposit and column F would be the running balance. The formula states....
if the check amount is blank then add the deposit on this row to the running
balance of the row above else subtract the check amount on this row from the
running balance of the row above.

hope this helped.
regards
FSt1


"Penny" wrote:

I'm trying to set up worksheets for church treasure. We would like one sheet
with only deposits, one worksheet with only withdrawls, and another with the
total activity in the check book. Is this possible or should I be looking
for another program??????