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