If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
having items posted in one worksheet appear in another
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?????? |
#2
|
|||
|
|||
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?????? |
Thread Tools | |
Display Modes | |
|
|