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!