Multiple Shipping Dates

[tjtjjtjt]

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

 

[Mark]

Hi,
if no-one can help you here, send this info and sample
sheets to me.

See my stuff at:
http:/au.geocities.com/excelmarksway
http://www.geocities.com/excelmarksway

Please be very specific as I can be a bit dim with
instructions.


(e-mail address removed)

regards
mark