Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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?????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting items from a list. To transfer to another worksheet? | Excel Discussion (Misc queries) | |||
How many items can a pivot table hold? i.e. a worksheet taps out . | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Is it possible to copy only selected items to another worksheet... | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions |