View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mscureman mscureman is offline
external usenet poster
 
Posts: 9
Default Transaction Classifications in Checkbook

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.