Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
importing multiple text files??? | Excel Discussion (Misc queries) | |||
How do I avoid saving multiple Excel/Wordfiles for versioning purp | Excel Discussion (Misc queries) | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) |