just to see if I am tracking here. You have a list/table of orders, somewhere else you have a list /table of inventory. You want a piece of code that will look at the list of orders and compare that to your inventory and the populate the table you put up as sample. Is that correct?
Posts by bslev
I may not be stating what I want to do properly, and that is why I cannot find an existing thread to help me out here. I have a simple table. Y represents a current running item, X is the next item to use/run. It takes different amount of times to go from one to the other. I am using an "INDEX" formula to see the times. By taking the items and rearranging them, I can get a shorter time to run everything (Scenario A vs Scenario B in my sheet). Is there a way with VBA to evaluate every possible scenario and find the best arrangement with the shortest total time?
I have attached an example. I am not asking anyone to write a code for me just point in the right direction, or better yet, an existing thread on here that might help me out.
Please and Thank you