Reposting from original post...........I'm okay at Excel with formulas and VBA but this one I just don't know where to start. So, I知 needing a formula that will extract one time for a part number that may have many instances but add the quantities for each instance. In the attached image I have the table "Parts and Quantities to Re-Order per SKU". A SKU can have up to 4 different part numbers. Columns W, Y, AA and AC are the part numbers required for each sku (sku not shown on far left) and the quantity to be deducted from "In-House" inventory just to the right of each part #.
In the Blue table, "Inventory to Order Per Part#", I have manually added each part number and its results down to line 8 just for demonstration of the result I知 looking for. The Blue table is where I need the formulas to extract the data from the "Parts and Quantities to Re-Order per SKU" table.
The objective is to get each part # in the blue table only listed once but to add the quantities required from each instance of the part number. A part number can be in any of the 4 columns depending on the sku so each part# would have to be looked at in all 4 part # columns. This workflow sheet goes clear down to row 228 and some weeks we can have almost all of the rows with a sku.
A formulas are preferred, rather than VBA, so that it will update as I enter sku's.
Hopefully the workbook uploaded.
Bookmarks