Hello
I have two lists of data which I am trying to combine as one output, this is basically a list of orders I have which I am looking to match up with relevant jobs.
I have attached an example spreadsheet showing what I am looking for, the list marked as Data 1 shows all the relevant PO's with the part numbers, quantities and dates.
The list marked as Data 2 shows all the jobs which are required with their relevant quantities.
The list marked as Output is what I am looking to achieve automatically, this shows the Data 1 & 2 merged together to show which PO & quantity goes to each jobs, the blanks show as excess stock from the previous PO.
Hopefully I've explained this correctly.
thanks in advance.
Bookmarks