Seeking help to develop a data table where I can get the product break down per production code when I just fill the order quantity as in the attachme

[konnen]

Hi all,
I request you people to help in making an excel sheet where when I enter the product daily production (product wise and code wise). When there is an order for the product , if I just enter the quantity for each product, excel should get me a code wise break down and the balance should be kept for the next order (first in first out basis).

[TABLE="width: 820, align: left"]
<tbody>[TR]
[TD="colspan: 4"]PRODUCTION[/TD]
[TD]BREAK DOWN[/TD]
[TD]BREAK DOWN[/TD]
[TD]BREAK DOWN[/TD]
[TD="colspan: 3"]ORDER[/TD]
[TD]BALANCE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RED[/TD]
[TD]GREEN[/TD]
[TD]BLUE[/TD]
[TD]PRODUCT CODES[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RED[/TD]
[TD]GREEN[/TD]
[TD]BLUE[/TD]
[TD]RED[/TD]
[TD]GREEN[/TD]
[TD]BLUE[/TD]
[TD]PRODUCT CODES[/TD]
[/TR]
[TR]
[TD]450[/TD]
[TD]150[/TD]
[TD]40[/TD]
[TD]AQ1[/TD]
[TD]450[/TD]
[TD]150[/TD]
[TD]40[/TD]
[TD]600[/TD]
[TD]247[/TD]
[TD]121[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]AQ1[/TD]
[/TR]
[TR]
[TD]520[/TD]
[TD]140[/TD]
[TD]70[/TD]
[TD]AQ2[/TD]
[TD]150[/TD]
[TD]97[/TD]
[TD]70[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]370[/TD]
[TD]43[/TD]
[TD]0[/TD]
[TD]AQ2[/TD]
[/TR]
[TR]
[TD]110[/TD]
[TD]310[/TD]
[TD]110[/TD]
[TD]AQ3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]110[/TD]
[TD]310[/TD]
[TD]99[/TD]
[TD]AQ3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] NOTE: IN BOLD LETTERS IS THE ANSWER I SHOULD GET[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Thank you all in advance,[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]