+ Reply to Thread
Results 1 to 10 of 10

Transaction Register Help

  1. #1
    Registered User
    Join Date
    10-28-2019
    Location
    Albuquerque, NM
    MS-Off Ver
    365
    Posts
    7

    Transaction Register Help

    I am trying to solve a problem. I have an Excel spreadsheet that I use to enter transaction data from my bank and show me a running balance. The problem I have is with split transactions. I want to split them, so I can track spending trends in a chart, but I don't want to enter them by simply adding another row manually. My goal is to have a "split" button that would activate a process (macro or VBA?) that adds a row directly below the current one and then adds some of the data from the current row into the new one. The ideas is, for example, I go to Walmart and make a purchase. I want to enter a row for that purchase for every category that applies. It may be one, for single categories, or it may be five. It all depends on the purchase. I have tried so VBA snippets and either they don't fit my needs, or they simply don't work when I test them. Any help would be great. Thanks.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,255

    Re: Transaction Register Help

    Hello stevenp1977,

    Welcome to the forum!

    If you can post some sample data with both before and after results, we can help you with this. Please redact (remove) any information that is personal or confidential before you post.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    10-28-2019
    Location
    Albuquerque, NM
    MS-Off Ver
    365
    Posts
    7

    Re: Transaction Register Help

    I have data similar to this:

    Attachment 648132

    As you see I had to enter a separate line item for each category of the same transaction. I am attempting to create an action (button, checkbox, etc.) to automatically add a row, copy the date & merchant, and somehow enter the amounts for each individual category without affecting a running balance.

    I tried some code like this:

    Please Login or Register  to view this content.
    When I clicked the button though, absolutely nothing happened. (This is an example snippet. I deleted the modified code when I deleted the button)

    I hope this helps.

  4. #4
    Registered User
    Join Date
    10-28-2019
    Location
    Albuquerque, NM
    MS-Off Ver
    365
    Posts
    7

    Re: Transaction Register Help

    **EDIT**

    I need to able to enter the category and amount. I don't need to event to do it for me. Sorry for the confusion

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,255

    Re: Transaction Register Help

    Hello stevenp1977,

    Something went wrong with your attachment. When I click on it, the system says it is invalid. Please try again.

  6. #6
    Registered User
    Join Date
    10-28-2019
    Location
    Albuquerque, NM
    MS-Off Ver
    365
    Posts
    7

    Re: Transaction Register Help

    I hope this works. It won't let me attach inline. Would you mind guiding me through this if you can't access it? Thanks.

    Excel Screenshot.jpg

  7. #7
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,255

    Re: Transaction Register Help

    Hello stevenp1977,

    No problem with your last post. The value in E2 is the Balance Forward, correct?

  8. #8
    Registered User
    Join Date
    10-28-2019
    Location
    Albuquerque, NM
    MS-Off Ver
    365
    Posts
    7

    Re: Transaction Register Help

    Yes. That is the balance forward. That needs to remain the same for all the rows that are breaking down the transaction into the respective categories.

  9. #9
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,255

    Re: Transaction Register Help

    Hello stevenp1977,

    Two more questions.

    I think I know the answer to this question but I am going to ask it. What formula are you using in column E?

    In your example bordered in red, will the amount show as Groceries -77.26?

  10. #10
    Registered User
    Join Date
    10-28-2019
    Location
    Albuquerque, NM
    MS-Off Ver
    365
    Posts
    7

    Re: Transaction Register Help

    No. Column E needs to be the ledger balance. So basically, that column reflects the accounts current balance, not the balance after the transaction has been split. Essentially that number needs to remain the same in all 3 of the highlighted rows. It's columns C & D that will change based on how the transaction is split. Also, it could be several rows depending on how the transaction is split, but I don't foresee more than probably 5. I hope I'm explaining it correct. Imagine Quicken, for example, that is what I am attempting to do.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Transaction Summary
    By MonkeyMonkey76 in forum Excel General
    Replies: 3
    Last Post: 01-13-2014, 09:27 AM
  2. Complicated set of calculations based on transaction IDs, transaction value, etc.
    By BeeZeRCoX in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-14-2011, 11:35 AM
  3. Date of last transaction
    By JMaderson in forum Excel General
    Replies: 12
    Last Post: 10-02-2009, 01:24 PM
  4. Last Transaction Value
    By Chimero in forum Excel General
    Replies: 4
    Last Post: 07-15-2009, 01:46 PM
  5. Transaction number
    By openofficeexcel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2008, 12:28 AM
  6. Transaction per minute
    By feejo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-18-2007, 10:57 AM
  7. getting the latest transaction
    By tweety127 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-06-2007, 11:27 AM
  8. how to duplicate a transaction register for my checkbook
    By mt2006 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-07-2006, 07:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1