having items posted in one worksheet appear in another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Penny - 25 Jan 2007 00:51 GMT

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

Reply to this Message

FSt1 - 25 Jan 2007 07:58 GMT

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

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

Reply to this Message