Multiple Shipping problem
I have a spreadsheet containing ship information for a client. Each
inventory item shipped is represented as a separate line. However, several line might be for the same PO. Each PO needs to have a single invoice. I need to create manual invoices for each PO. I have previously used a vlookup function and input invoice numbers one at a time, and it would use the invoice number to look up the relevant data and fill in the appropriate field son the invoice. The problem is that works fine if there is only one inventory item per PO. The challenge is how to populate multiple lines of ship data for the same PO Thanks, Tom |
All times are GMT +1. The time now is 08:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com