having items posted in one worksheet appear in another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??????
 
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
 
Back
Top