I have the sheet attached with a Date, Delivery Date, Plant Name, and a list of products with the other data…

When I submit orders the data goes to a submitted order sheet as you can see…

I want to be able to enter the Delivery date hit the insert invoice button and it will pull the orders from the submitted orders sheet that have the plant name as well as the delivery date of the one that is entered…

So for delivery date of 1/15/15 and plant name MYRONPT1 we want to bring all the data from the submitted order sheet to the order sheet…

Check the example file and I think you will understand better of what I am trying to do...

THANKS IN ADVANCE FOR ALL HELP!!!

exampleinvoice.xlsx