I feel so silly asking this questions. It's been a few years since I've used Excel.
Context:
I have a master order form. In that form, there is an invoice number, no. of items to be delivered and what store is getting the delivery.
What I need:
A new sheet for my delivery driver (almost the same as the master sheet but with some more info for him and the store to complete. How I am picturing this sheet is that it would look to the master sheet to see what orders are there (looking at the invoice number and if the master sheet has an invoice number, it would populate that invoice number in addition to the store name and products to be delivered. I can't just copy my master sheet, because there are orders on there that would be delivered on different days. My delivery sheet would be for that day only. Sorry if this sounds confusing, I'm sure it's easy peasy, I just can't wrap my head around it. Thanks all & have a great day!!
Context:
I have a master order form. In that form, there is an invoice number, no. of items to be delivered and what store is getting the delivery.
What I need:
A new sheet for my delivery driver (almost the same as the master sheet but with some more info for him and the store to complete. How I am picturing this sheet is that it would look to the master sheet to see what orders are there (looking at the invoice number and if the master sheet has an invoice number, it would populate that invoice number in addition to the store name and products to be delivered. I can't just copy my master sheet, because there are orders on there that would be delivered on different days. My delivery sheet would be for that day only. Sorry if this sounds confusing, I'm sure it's easy peasy, I just can't wrap my head around it. Thanks all & have a great day!!