If conditions meet, transfer data from sheet to another with its date

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

Are you "locked in" on the format of your Stocks worksheet?

The layout makes it very difficult to work with!

If the information was on ONE ROW, with Col Headings for Stock, Date, Open , Close and Movement it would be a lot easier.

DAC

That's the worksheet. Do weekly for 5 days. If you preview print, it will fit 2 pages perfectly.

I think the code should looks like this, but I cannot figure out how to write it...

Please Login or Register  to view this content.