Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to modify a checkbook register template so that I can assign
classification codes to each transaction, then have a copy of all transactions of a given type go onto a separate worksheet. I want to be able to show a separate register (I'm copying the layout of the main register) that has basically pulled out the transactions of the specified type and have a balance for that type (which will be different from the main register). Ex: Number Date Description of Transaction Class Credit Debit Balance 100 1/1/2000 John Q Public P 350 1000 101 1/2/2000 General Electric U 400 650 D 1/3/2000 Deposit P 1000 1650 102 1/4/2000 Mary Johnson P 575 1075 I'd like to be able to pull all the "P"s onto a separate worksheet and run a separate balance so I know how much is in the "P" account. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transaction type/ Transaction amount in two separate columns | New Users to Excel | |||
trying to add up disparate transaction data | Excel Worksheet Functions | |||
how to duplicate a transaction register for my checkbook | New Users to Excel | |||
calculating term of financial transaction | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions |