I am trying to create a PO / Invoice tracking system for my team. One sheet has all the blanket PO #'s and amounts and the other has all the invoices that are tied to each PO.
So if an invoice is added to the invoice sheet that has a matching PO number to a PO on the PO sheet, the PO amount would decrease by the invoice dollar amount.
Does this make sense?? And does anyone have any ideas on how I can accomplish this?