This is my first post here. I appreciate any help.
What I need to do is look up the lowest cost shipper for each order item from a different workbook. Also, it must be the lowest cost shipper with an arrival date early enough to meet the customer’s request. My strategy so far:
1 Sort the separate Cost workbook by OrderID, then by Arrival Date, then by Cost.
2 Set a range in the Cost workbook that includes the above.
3 Loop through the range, and for each OrderID, find the least cost shipper with an acceptable arrival date.
4 Post that cost and name of shipper in the original workbook/worksheet (named Assignment).
I think I can use this strategy with a MINIF function, but I have struggled for a long time to develop the right syntax.
This is my code so far:
Thanks for any help.
Bookmarks