Find equal values in two ranges and get their positions and..(hard to explain)

[salati]

Hi,
I am new to VBA and to the forum as well. And I can´t find a way to solve this simple warehouse problem:

All columns are obtained from another Workbook, so the dates, values and range sizes will change from time to time. The first date column is just a daily sequence. The second date column are the dates when material got in or out the warehouse. I actualy only don´t have the colored balance information, which is the balance in each day. I want a code that considers the second balance column and put them into the colored range. Any ideas?

 

[sunnyland]

Putting in B4 the following formula then drag down. It should give the right results and you won't need Balance in column F

=B3+SUMPRODUCT(($C$4:$C$12<=A4)*($C$4:$C$12>A3),--($D$4:$D$12="in"),$E$4:$E$12)-SUMPRODUCT(($C$4:$C$12<=A4)*($C$4:$C$12>A3),--($D$4:$D$12="out"),$E$4:$E$12)

the row 3 need to be present with no data in A3 and starting Balance in B3 or 0

Hope it works as intented.