im trying to pull multiple dates with one customer
friday monday
part qty date qty date
PIZZA 25 6/20/2015 50 6/30/2015
KIMS 25 6/25/ 40 7/15/2015
LEVYS 30 7/20/2015 100 10/15/2015
i have a report ran everyday for shipment dates and is placed on another sheet. i want to know if it is possible to pull in multiple dates when i pull the report on Friday.
ex. On Friday for KIMS there is a shipment for 6/25 but on Monday, the shipment was canceled and the next recent is not till 7/20. i want to be able to pull both the 6/25 date and the 7/15 date in on friday so i know what the next shipment is in case a delivery is cancelled and the next date is soon after.
if possible i would like it so that the next date shows in the row beneath the row with the customers name
(i tried to insert a screen shot of the sheet not sure if it worked)
Capture.PNG
Bookmarks