LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transaction type/ Transaction amount in two separate columns Mike New Users to Excel 5 November 9th 06 02:38 PM
trying to add up disparate transaction data bill adkins Excel Worksheet Functions 2 September 17th 06 11:59 PM
how to duplicate a transaction register for my checkbook mt2006 New Users to Excel 1 January 7th 06 11:14 PM
calculating term of financial transaction bookman3 Excel Worksheet Functions 4 July 26th 05 05:25 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


All times are GMT +1. The time now is 09:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"