The attached is a mess but is only work in progress.
I've concentrated on 'Which are the sizes I can use from my existing stock to meet my customers demand?' because there are currently no exact matches of the requirements in stock at all.
There's a table at cell K3 of the attached which is a repeat of your table at cell F3 with an added column which is a list of stock Sl Nos where there is not zero stock and where you should be able to cut the required size from larger stock sizes. The list is in the same order as your existing stock list.
At the moment, that list lists the SL No and the stock size in the form:
SL No: nn*nn*n
If the data in either of your 2 tables change, to update the new table, right-click it and choose Refresh.
Does this look like it could be the start of a way forward for you?
|