Take Data from Log Sheet and Disburse to Balance Summary Sheets

Hi all

I work in the Budget office at my place of work and am building a Log/Database to track all of our different funds and their balances. When money is transferred out of one fund and into another it gets put into a spreadsheet where we have to input it twice (once in the main log, and another in the fund worksheet).

Being rusty on my programming I would like to create a Macro using a Command Button (Active X Control) where once a user has inputted an entry, all they have to do is click the Command Button and the spreadsheet will automatically update the balances and logs of other sheets.


We have about 12 funds that we use. In the main log there is a row for TBA Number (for logging purposes), Fund, Account #, Description, Amount, Analyst, and Date. I want to take from that spreadsheet, if say Fund X is inputted, to the Fund X Balance Log where the columns are TBA #, Account, Description, and Amount.


Sorry if this is a little confusing but any help would be appreciated!

Submit an example workbook, with some fake data, and clearly demonstrate what cells are the input cells and where they should be output to.

Attachment 1 is the main log
Attachment 2 is the one of the fund tracking logs, there will be 6-7 others.


Snip1.JPG
Snip2.JPG

I do not see any attachments.

I posted to pictures, did they not show up?

I would rather not have to build a worksheet from scratch to test the code, hence why I asked you to submit an example workbook with fake data. This site allows the attachment of workbooks through the Go Advanced link on the bottom right. Also, and I stress this, it needs to be clear to us what information goes where (most of the time coding is very specific)

here's a rough look at it. Instead of the 2 funds at the bottom, there will be about 7-8, but once I can wrap my head around the coding for 2, I can just repeat the process until the loop ends at 8.

Thank you for the help in advance

2015-16 TBAs Log Excel Forum.xls

I still have a few questions but try this and see how close it is.

Please Login or Register  to view this content.

That works just fine.

When you run it twice, it will just copy the previous entries and enter those (creating duplicates) is there a way to create it to where it only takes new values and doesn't copy the old ones?

Better yet, have it delete all of the fund balance work sheets and start over fresh, to erase the copies.

But it essence, the code runs as it should.

Please Login or Register  to view this content.

This is perfect. Thank you so much! Adding a few things of my own in there, but thank you so much!