Populate a dynamic ITEMIZED LIST with ITEM NAME in one column and the QUANTITY in another

[jprhodes5493]

I am building an inventory management system in Google sheets that will tell our ******* what to produce every day based on the numbers of sellable items we have on shelf.

Our ******* only produces certain items on certain days and thus I want to create a list that clearly shows them what to make.

I have a sheet that shows all of our items and the quantity of each that the ******* needs to produce on that particular day.

However, I would really like the sheet to only show ONLY what items need to be made that day and the quantity of each.

This is my "What2Make" sheet that has all of my calculations and produces the Quantity (in column I) to be produced of the particular Item (Column A). I have hidden the calculation columns (ColumnB through ColumnE)

Cell A1 is the indicator of what ITEMS are supposed to be produced on that particular day. Every day this number changes and so do the values in Column F and Column G based on what is currently on shelf at the particular location.


What2Make
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]QTY of What 2 Make for Location A[/TD]
[TD="align: center"]QTY of What to Make for Location B[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Item 1 (S)[/TD]
[TD="align: center"]Don't Make[/TD]
[TD="align: center"]Don't Make[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Item 1 (M)
[/TD]
[TD="align: center"]Don't Make[/TD]
[TD="align: center"]Don't Make[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]Item 2 (S)[/TD]
[TD="align: center"]Don't Make[/TD]
[TD="align: center"]Don't Make[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]Item 2 (M)[/TD]
[TD="align: center"]Don't Make[/TD]
[TD="align: center"]Don't Make[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]Item 3 (S)[/TD]
[TD="align: center"]12
[/TD]
[TD="align: center"]8[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]Item 3 (M)[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]9
[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]Item 4 (S)[/TD]
[TD="align: center"]Don't Make[/TD]
[TD="align: center"]Don't Make[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]Item 4 (M)[/TD]
[TD="align: center"]Don't Make[/TD]
[TD="align: center"]Don't Make[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]Item 5 (S)[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"]Item 5 (M)[/TD]
[TD="align: center"]12
[/TD]
[TD="align: center"]
8[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: center"]Item 6 (S)[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: center"]Item 6 (M)[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]12[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: center"]Item 7 (O/S)[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]4
[/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: center"]Item 8 (O/S)[/TD]
[TD="align: center"]Don't Make[/TD]
[TD="align: center"]Don't Make[/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: center"]Item 9 (O/S)[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]5
[/TD]
[/TR]
</tbody>[/TABLE]




The format of the list the ******* will printout is:

Production Log/Packing Slip
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Location A[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Location B[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD="align: center"]Item [/TD]
[TD="align: center"]Small[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]O/S[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Small[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]O/S[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Item 3[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]Item 5[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]Item 6[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]Item 7[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]11[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]Item 9[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]10[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]


If this is not possible, I would at least like to have a list of just the items and the numbers that need to be produced. Essentially exempting any row with "Don't Make".




Whoever can give me some guidance as to how I will make this work I will be forever grateful and you will be a life saver!

Thank you and best of luck,
Parker