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). PRODUCTION BREAK DOWN BREAK DOWN BREAK DOWN ORDER BALANCE RED GREEN BLUE PRODUCT CODES RED GREEN BLUE RED GREEN BLUE PRODUCT CODES 450 150 40 AQ1 450 150 40 600 247 121 0 0 0 AQ1 520 140 70 AQ2 150 97 70 370 43 0 AQ2 110 310 110 AQ3 0 0 11 110 310 99 AQ3 NOTE: IN BOLD LETTERS IS THE ANSWER I SHOULD GET Thank you all in advance,

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

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

Thread starter konnen
Start date Aug 27, 2018
Tags

data input table easy easy show up excel excel & formula

konnen

New Member

Aug 27, 2018

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).

PRODUCTION	BREAK DOWN	BREAK DOWN	BREAK DOWN	ORDER	BALANCE
RED	GREEN	BLUE	PRODUCT CODES				RED	GREEN	BLUE	RED	GREEN	BLUE	PRODUCT CODES
450	150	40	AQ1	450	150	40	600	247	121	0	0	0	AQ1
520	140	70	AQ2	150	97	70				370	43	0	AQ2
110	310	110	AQ3	0	0	11				110	310	99	AQ3

NOTE: IN BOLD LETTERS IS THE ANSWER I SHOULD GET

Thank you all in advance,