Hello All

Before i start i just want to say sorry if my question don't make a lot of sense please ask for more info if you need.

I have a workbook with 2 sheets in it sheet one is called goods in with 9 standered fields for products

Date ;PO no ; Code ; Description ;Size ; Qty ; Qty left ;Location ;Notes

I time stamped my date column.

My second sheet is called Products out

Date ; PO no ;Code ;Description ;Size ;Order No ; Qty Out ;Notes

Date is Time Stamped PO no is doing a look up to goods in for the relevant PO no so is code; description; size from the goods in sheet

This is where i im stuck what i am trying to do is take the Qty out and deduct it from the Qty in to give me the qty left for specific PO no and Product Code is there a way i can do it in excel

I have some VB knowledge but not enough to safe my life im using Excel 2007

thanks in advance for all help and assistance.