Comparing 2 worksheets

C

Cube Farmer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top