Hi,

I want to create a macro that will check the "Stocks" tab and will transfer the total for each Stock type (#001, #901, #141) to DataBase 1 (#001, #901) and DataBase 2 (#141) if the total amount of each day is other that "zero" by adding the date accordingly.

The result should looks like in the DataBase 1 and DataBase 2.

Not sure if this can be done with formulas.

Can anyone help? Thanks!

Stock Balance.xlsm