I need an Excel Expert

Job ID: 34823734

Budget: €750 – €1,500 EUR

I have two lists:
- a bill of material showing with the following columns: product code, drawing no., qty
- a list of product with the following columns: product code, delivery date first lot, qty lot 1, delivery date lot 2, qty lot 2

I need to allocate the product of the second list to the drawings of the first list, showing the latest date of reception of material for each drawing .
Related categories: Visual Basic Data Processing Data Entry Excel