Hi,
thanks in advance for any assistance with this.
I have a page with each supplier and their lead time for delivery from placing an order.
I have a page with the items from each supplier that is required each month
I would like to create a page that shows when orders have to be placed to insure delivery before the parts from each supplier is required
I have linked 2 photos for you to see what I mean.
http://uploads.im/lD24P.jpg
http://uploads.im/UF4gG.jpg
I've been trying SUMIF, IF etc but I cant quite get the 3rd page to pull the amount to be ordered in January to populate from the lead time
Bookmarks