Procuct Summary

[rizmomin]

Please refer to attach sheet ...
Sheet Jul10 list the quantity order for our business.
Column B : Qty Received
Column D : Item #
Column I : Date of Delivery

In "Product Summary" sheet:

I need a macro to accomplish following:

I need Quantity received from Jul10 sheet summarized in "Product Summary" based on Item #
listed in Row 3 ..Basically match the item # and add quantity in proper cell.

I have completed manually for 7/5/2010 as you can see on Row 8 of "Product Summary" Sheet.

Please let me know if you have any further questions..

Thank you in advance for your help.

Riz