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.

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.

**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

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

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.

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.