I have 2 worksheets:
Forecast and Shipped

Forecast:
Cust. Part# Due Date Qty
ABC 123 7/10/05 200
ABC 123 7/20/05 200

Shipped:
Cust Part# Ship Date Qty
ABC 123 7/15/05 250
ABC 123 7/18/05 50

I want a summary sheet to show:
Cust Part# Due Date Qty Ship Date
ABC 123 7/10/05 200 7/15/05
ABC 123 7/20/05 100 7/15/05

Is this possible?

Thanks,
Mike